Issues

Idrissshatila · ‎06-12-2024

Hello, Refresh of individual tables does not seem to work in the latest June 2024 version of Power BI desktop. It was fine with the May 2024 version. I even tried re-installing Power BI. However, nothing seems to work.

CKGZA

The conditional formatting is no longer visible in the Dashboard view of Power BI Service. However, if you click into the underlying report, then it is visible. This is a problem to our users who only want the dashboard view on their mobile. I searched the forum and found older issues which suggested clearing the data cache as a solution. This did not work for me. Please look into this and resolve.

georgiKocev

Hello, I have created myself an onmicrosoft.com account and subscribed for a Fabric Trial. The problem is that when I try to create a Fabric item I always get the following error: Unable to create this item To create a Lakehouse, you need a free Microsoft Fabric trial capacity. Unfortunately, your Microsoft tenant has reached the maximum number of available free trial capacities. Go to the documentation to see your options. Could you help me to fix this error, please? Thank you

Andyrice1989 · ‎06-12-2024

Since the latest upgrade none of our boolean columns work in power BI. We're using direct query and snowflake. Has anyone else encountered this? is there a workaround or fix as it has impacted a large number of our reports. Thanks

JamesDenman · ‎07-06-2024

(The moderator @foodd in the "Power BI forums \Forums \Get Help with Power BI \Power Query" forum suggested I post this here; the moderator in the Microsoft Community forum suggested I post in the Power BI forum...) According to MS, it should be possible to update PQ queries in Excel Online: https://support.microsoft.com/en-us/office/use-power-query-in-excel-for-the-web-02652946-de70-48d8-8... However, when I try (open workbook in Excel Online; right-click on results table; select "Refresh") I get the error message "COULDN’T REFRESH DATA Power Query queries in Excel for the Web can’t be refreshed in workbooks saved in a third-party cloud location". (I actually get a similar message in German, but I think the above is the English equivalent). What I don't understand is: my file is saved in OneDrive. That's a Microsoft service, i.e. NOT a "third-party" cloud location. This behaviour appears even when the Excel workbook is empty except for a single query "let Source = 3 in Source", i.e. it isn't referencing any other external sources. I am using a Microsoft 365 Family licence, the current version of Microsoft Edge and Windows 11 Home. Either the behaviour or the error message is faulty. Can you please tell me which of them is wrong, and pass the problem on to the developers to fix? Thanks and best regards, James Denman

cheriebon1614

Hi Team, I am having an issue with one of our dashboards on Power BI Service. We have 4 matrix visuals pinned to our dashboard which use measures via formulas to show custom titles, and conditional formatting on the values within the tile on the dashboard. This was working on Friday the 5th of July 2024, however, when I came into work on Monday the titles and conditional formatting had disappeared from all 4 Matrix visuals. These matrices come from 3 different Power BI Service reports. All matrices use data groups and a single measure to show the values in the visual. I also have line charts on the dashboard which also use custom titles via measures entered into the formula option for the title. The line charts all show the custom title on the dashboard. I have tried to research on the Fabric Community website to see if anyone else had recently has posted a similar issue with no luck. I also have tried the following tests as suggested in older posts that I found: I confirmed that we are using the latest version of Power BI Desktop June 2024. This had not changed between Friday and Monday. I was using the June 2024 version on Friday when the matrix visual was showing the title and conditional formatting. I have tried to use another browser to see if the issue still occurs. It does. I have cleared the cache in my web browser, and we are using a version of Microsoft Edge that is later than 120 as suggest in one post. I have changed the visual type to a table and then pinned it again to the dashboard and could see the title and the conditional formatting in the tiles. I re-created the matrix visual from scratch to see if that would then show the title and conditional formatting and pinned this new visual to the dashboard to see if this would show the title and conditional formatting. It did not. The title and conditional formatting do show in the tile on the dashboard if not using a formula/measure (i.e. when using the default settings in Power BI Desktop such as manually entering the title and formatting each individual measure). I can confirm that the measure that we are using is a string as I've seen posts that suggest that when using formulas/measures for dashboards that it must be a string. I then tested to see if this was occurring on another workspace, and it is occurring on all our development workspaces including our production app. It seems that it is an issue with the matrix when using formula/measures to display the titles and conditional formatting. I have also noticed that when adding a title to an image and trying to deploy it to the service, does not allow me to pin the image to the dashboard. I was going to use this as a workaround in order to be able to see the date in the dashboard without having to do this within the matrix visual. But this is a side issue and not my main concern. Any help in resolving this issue would be greatly appreciated. Thanks.

maxbarj · ‎06-27-2024

Hello, I have noticed there is an issue with zoom sliders on the clustered column chart visual. When you don't enable the data labels and enable the zoom slider on the Y axis everything works just fine. However, the zoom slider on the Y axis breaks when adding data labels. Issue is occuring on Power BI desktop and on Service. Similar issue have already been reported and fixed back in 2022 Looks like it is broken again.

Idrissshatila · ‎04-08-2024

I noticed that couple of users have posted about having the values in filter pane on service showing in black when using a dark theme, this is preventing from the ability to see the values to be selected.

JPritch · ‎06-18-2024

The new card visual with reference labels appears fine in Desktop, but disappears in Service. I've isolated my issue to the Details toggle. When OFF, ref labels do not show in service. When ON, ref labels appear in service. I don't need to show any details so need this toggle set to off. This issue began on 6/17/2024 for myself, and another user in this thread: Another issue related to new card visual Photo below (left is Desktop and right is Service): @migueloros @foodd

SauravRajJoshi · ‎06-25-2024

Hi, I am trying to create a On-Premise data gateway(Standard) on an Azure VM or my local machine, which is connected to the on prem SQL server via a VPN. I have tried reinstalling the on-premise gateway multiple times on different machines, and always get this after installing. All the documents and videos show this instead: The permissions I have are: In Microsoft Fabric: The gateway is not listed on Fabric, can't find it on Gateway Cluster name dropdown either. Is there any solution to this?

Rita212 · ‎06-16-2024

Hi~The gridlines were turned off in the original pbix file but appeared in the report that was already published in workspace, please kindly have a check.

jonathansb · ‎05-23-2024

Existing reports that use the standard map objects are not loading. Just come out as blank. I have checked across multiple reports both in the web and desktop, but doesnt seem to work anywhere. Also confirmed with other colleagues in company and they have the same problem. Is this a known issue? and will it be fixed promptly?

TM_Visual · ‎06-19-2024

This is an on-going minor problem that has affected my team for a long time. I can add a new user to an app audience (or prior to that, the access list) and update the app. However if I change the user list and one of the existing users in that audience has left the organisation, the app will not update. This is because their account is deactivated. The error message is: The following groups have failed validation : "12345678@company.com"; "12345378@company.com"; "56345678@company.com"; "12341178@company.com"; "12340088@company.com" To publish the app with new users the error must be closed, then the users manually removed from the audience by finding their name in the access list. This is awkward for several reasons: 1. There are often many users that have left the organisation and need to be processed in this way. 2. When an app has a large distribution list to scroll through it takes time to find the correct person. 3. All users have an underlying identity in the format 12345678@company.com. We also have an email identity as name.firstname@company.com . The error message shows the ID number@ email address of staff, but the audience lists their name.surname@ email address . The ID numbers are not known. We have had to develop another system to retrieve staff names from the ID number that is shown. The names are obviously being linked up somewhere in Power BI's identity system, as the error message IDnumber@company.com email addresses are listed in the alphabetical order of the name.surname@company.com of the users! I believe that this issue is likely due to this identity system used by my org. Perhaps Microsoft's identity management system is viewing each of our users as their own 'group'. We are able to assign access to groups of users, but we don't want to control all access via the group system, both because there are additional steps and because groups can't capture the complexity of access rights required. My ideas for solutions to this problem include: - Allowing apps to be published despite invalid users. - Providing an option for users publishing an app to remove invalid groups or users automatically. - Display invalid accounts at the top of the list of users so it is convenient to remove them. - Reconciling the identities of single user groups, or however my organisation is likely to be using the identity system.

rsizer · ‎06-17-2024

Hello. We are having an issue with new versions of Power BI desktop. We are using direct query to connect to our data. Reports that have been working fine for several months are now showing the "query folding" error when we try to run them. This happens when we updated to the June 2024 release of desktop. This is a pretty big bug as it breaks all our reports. We were able to roll back to the May version, but I'm worried this will continue to be broken in subsequent releases.

Greg_Deckler · ‎03-26-2024

In Table view, right-clicking the table in the central area and choosing Copy or Copy Table doesn't do anything. Nothing is copied.

InTheDark · ‎06-27-2024

We recently upgraded to May 2024 for Power BI Report Server (both server and desktop software) and we're running into a bug. Maxtrixes are not allowing us to use the Tabular or Outline formatting when published. They look fine in desktop, but once published on the server, they look like the default Matrix layout (compact). I submitted a forum post about this issue with images here: https://community.fabric.microsoft.com/t5/Report-Server/Matrix-Format-Changes-When-Published-to-Power-BI-Report-Server/m-p/4011241#M35650 I'm including the link because this page is not allowing me to upload all the images. Other users on that thread were also able to recreate the issue. If you use an older version of the Desktop for Report Server (like January 2024), turn off stepped layout on a matrix, then save it to the May 2024 Report Server, the formatting is maintained. I think the actual server is still looking for that stepped layout option, but the associated desktop software is using the new Tabluar/Outline/Compact language.

PaulPrayoon · ‎06-11-2024

Hi, I created this report with Power BI - MAY-2024 and it's working just fine until this morning new version of JUN-2024 was auto-updated to my notebook. JUN-2024 version caused the report to be like this. New Card visual doesn't work properly with JUN-2024 version, all Reference labels disappeared I guessed it's a Defect in this version (JUN-2024)

HewBR · ‎05-31-2024

In the May 2024 release(s) of Power BI (including version QF1 2.129.1229.0), there is an issue with the DAX Query View where the 'Copy' function does not work as expected. Although the 'Copy' button is available and no error message is displayed, clicking the button does not copy the results to the clipboard. One of the key features of the DAX Query View is the ability to export intermediate query results, refine or filter them in Excel, and further improve them using DAX. This feature is especially beneficial for users transitioning from Excel to Power BI. Perfect, MS! However, the inability to copy and paste query results significantly reduces the functionality of this tool. Steps to Reproduce the Bug: Create a query in DAX Query View. Click the 'Copy' button. Attempt to paste the results in any text editor or Excel. Expected Result: The selected query results should be copied to the clipboard and should be pasteable in any text editor or Excel. Actual Result: Nothing is copied to the clipboard, regardless of whether cells are selected or not. Please address this issue to restore the full functionality of the DAX Query View.

daaa · ‎06-02-2024

This is a copy of: https://community.fabric.microsoft.com/t5/Issues/Test-as-role-quot-not-supported-quot-message-for-composite-model/idc-p/3965157#M107651 I have created this new one, because the old one seems to be completely ignored, even though it has got a lot of attention. _________________________________________________________________________ I have report which uses a composite data model, with a mix between DirectQuery to other Power BI datasets and some imported tables from SQL Server. The model also uses calculation groups, allthough I do not think this is related to the issue. The data model also has RLS, and I can test this in desktop and it works as intended. However, when I publish the report to the service and I want to "test as role", I get the following error message. Is this a bug, or is "test as role" really not supported for a composite model?

PurpleWave22 · ‎10-20-2023

Hello, I posted this in the help section of the community, but I believe it is a bug with the most recent update (October 2023). I routinely export desktop PBI reports to PDF for sharing in newsletters. Today, for some reason, when I exported to PDF, only about the top left quarter of each page is exported instead of the full page. I have attempted exporting multiple different reports, closing and re-opening Power BI, and restarting my computer to no avail. Nothing in my report has changed other than refreshing the data. Each page is the default 16:9 720x1280 size. I was able to successfully export from a report published to the online workspace, but not desktop. A coworker was also able to successfully export from desktop with the August 2023 update. Link to help thread with numerous others with the same issue Any help in getting this resolved would be appreciated!

Share your ideas and vote for future features

Single table refresh not working in June 2024 version of Power BI desktop

Conditional Formatting not working in Power BI Service

Issue with Fabric Trial

Snowflake boolean columns no longer working in new PBI version 2.130.754.0

Issue: Power Query not working in Excel Online

Power BI Dashboard - Formulas disappeared from tiles

Zoom slider not working on Y axis when data labels are enabled (Desktop and Service)

filter pane values in service are showing in black when the page color is dark

New Card Reference Label values disappear in Service

On premise gateway not showing up in Microsoft Fabric

The gridlines were turned off in the original pbix file but appeared in the published web report

Standard map objects are not working

Unable to update app until users are removed: 'groups have failed validation'

"Query Folding" error after Desktop update

March 2024 Breaks Copy Table

May 2024 Report Server Does not support Maxtrix Layout options in May 2024 Desktop for Report Server

Issue with Power BI - JUN-2024

Copy Function Not Working in DAX Query View (may 2024 and QF1)

Test as role "not supported" message for composite model new

PDF Export From Desktop not Exporting Full Pages

Helpful resources

Fabric Source Control No related workspace misspel...

Powerbi reporting builder sparkline not showing va...

Issue with Fabric Trial

can't download CloudScope Image (PBI certified)

PowerBI Push Dataset Relationships not working in ...

European Microsoft Fabric Community Conference

Share your ideas and vote for future features

Helpful resources