Issues

QueenTink

We are wanting to use direct query for our datasets so we are not limited to how often we can refresh an imported dataset. We are running into an issue of with datetime fields coming from Starburst. Power BI doesn't support timestamp(9) as a date field and we are unable to convert the field data type due to the limitation of direct query. Are there any date formats from Starburst that Power BI supports? We haven't found any.

o59393 · ‎09-17-2023

Dear MSFT Recently I've noticed that calculated column and dax measures s are going blank or unchanged after writing code. Can you review this potential bug from September version? Thanks.

christianirgens

"Analyze in Excel" works nicely in the web-version of Excel. In the Excel application we have the following issues: 1. Only measures can by aggregated (i.e. not possible to sum numerical variables without defining measures). 2. The interaction between connected datasets does not work. Item 2 is a show-stopper for any application with more than one data connection. Are there any other workarounds than denormalizing the data (one "flat" data source)?

jaykayelsemicol · ‎04-20-2023

In Power BI Desktop I am running into an issue where I cannot format visualizations that are part of a group. When selecting the visualization in the group and navigating to the Format visual tab, no options are available and it says "Formatting options are unavailable for this visual". The only workaround is to ungroup the visualization, make formating changes, then re-group it with the other visualizations. This has been happening for the past week or two. Sometimes it will let me format visualizations in a group, but most of the time it shows the message below.

sebadb9 · ‎05-12-2023

Publishing a power BI desktop file to power BI service, in an attempt to overwrite an existing dataset/report doesn't work whenever you might have switched on the toggle of OneDrive refresh. Turning of the toggle doesn't solve the issue. Reported issues, claimed to be resolved by the product team, continue to cause big issues: Cannot disable OneDrive refresh - Microsoft Power BI Community. This result in a status where it is impossible to adjust a dataset/report. (Even though Microsoft is pushing towards full parity of power BI desktop into the cloud, currently we can't fully work in the browser as not all functionality of power BI desktop has been added in the browser.) The only unacceptable workaround appears to delete your dataset/report in the service and publish a new one. Let me elaborate some of the consequences of deleting the dataset/report: need to re-pin visuals to dashboards RLS/OLS needs to be reconfigured related reports/datasets are broken (hybrid reports, reports on the same datasets, etc.) all reports directly or indirectly related to this dataset that are pinned in Microsoft Teams are broken Deep Links (with filters in the URL) to every report related directly/indirectly to this dataset are broken all people's bookmarks to related reports/datasets are broken integrations of power BI reports in PowerApps are broken integration in Excel Custom data types are broken (featured tables) integration of power BI in Power Automate are broken, automation of processes thus are broken all external systems sending API requests to that dataset are broken metrics are broken report usage metrics are gone power BI comments are gone integration with Synapse Analytics is broken e-mail subscriptions on the reports are broken alerts on Card/Gauge visual are broken everything else I forgot about is broken! Let it be very clear: the impact of deleting just a simple report/dataset can be huge. Huge work in fixing stuff, huge in disruption for the business with a many power BI users. Currently we're not updating our power BI reports and datasets, which also is impacting our business operations! All power BI users are facing this issue and many are complaining about it: https://community.powerbi.com/t5/Service/Couldn-t-publish-to-power-BI-already-exists-and-is-set-up-w... https://community.powerbi.com/t5/Developer/Publish-of-update-fails-with-error-about-cloud-refresh/m-... https://community.powerbi.com/t5/Service/Cannot-quot-overwrite-quot-You-already-have-a-dataset-named... https://community.powerbi.com/t5/Developer/Publish-of-update-fails-with-error-about-cloud-refresh/m-... The product team should fix this and have admins the possibility of disabling OneDrive refresh all together for the entire tenant. Simply moving one .pbix file in SharePoint (seeming unharmful) can trigger unrepairable/irreversible consequences. I have raised a support ticket for this issue, but power BI support has been unable to solve this open ticket for more than 5 days. Please vote, and raise awareness of this BUG. This must be fixed!

NickJ2011 · ‎06-15-2023

Getting the error below, even when refreshing one dataflow at a time. There was a problem refreshing your dataflow. RootActivityId: 394090f0-0dd4-44ad-9ac8-76aeff5192d8 ErrorMessage:Refresh has failed unexpectedly. This indicates in most cases an out of memory issue in your capacity. Please check the capacity configuration metrics and try again.

wilsonchen · ‎09-14-2023

Hi, I have encountered same issues from time to time. For slicer set as single-select in PBI desktop revert to multi-select on PBI service. I have looked on the forum and checked every possibilities (Bookmark Solved: Single selection slicer reverts to multi-select - Microsoft Fabric Community, etc.). Right now I have to modify the slicer on Power BI services whenever I published the report. I believe this is a long-standing issue and want to raise PBI dev team to be aware of this annoying issue. Walkaround or solutions to the issue are highly appreciated. Thank you!

aJayMitchell · ‎06-08-2023

After pressing Alt+Enter to add a new row when coding a DAX measure, the shortcuts such as 'H' for Home, 'JT' for Table Tools, etc are remaining active. When I press Alt+Enter in other programs such as Excel, it picks up that I was using the Alt key as part of inserting a new line and therefore doesn't show the shortcuts/expects the next keystroke to be a shortcut. Within Power BI, it is waiting for the next keystroke to be a shortcut - and therefore keeps putting me out of my flow with writing DAX as I need to click back into the formula bar so that I can continue typing. This is incredibly frustrating and needs to be resolved ASAP.

Nhigdon_ST · ‎09-12-2023

When trying to publish an embed code, we get warned we need to disable Azure Private Links, but we try to with an admin account, only to not let us save the setting

Tiemen · ‎05-31-2023

Hello, The datasets in the new Admin monitoring workspace wont refresh anymore. Also it is not possible as an Power BI admin to get an Admin role for this workspace. So i can't check te dataset settings. Error details: Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"The credentials provided for the AdminInsights source are invalid. (Source at AdminInsights.)"}}],"exceptionCulprit":1}}} Cluster URI: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net Activity ID: 706ff8a3-0141-46d3-870f-5ac5c38258b7 Request ID: aaee75b8-262c-4e9e-87a6-158967a5a2d5 Time: 2023-05-28 09:42:21Z

michelarnaout · ‎09-12-2023

Reports have been erroring and stuck in a refresh loop since 09/10/2023 Gateway is online and reports locally refresh normally Cluster URIWABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net Activity IDb8147d66-0a01-4d1a-987f-20d2df4a817a Request IDc16885cf-5ad3-49f2-b872-5e09fc02a7cf

daaa · ‎09-12-2023

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?

JoshT · ‎08-17-2023

We've noticed a number of bugs relating to usage reports, mainly around the datasets: In the new usage report, the 'Save a copy' option in the File dropdown doesn't appear until the page is refreshed When using the 'View dataset' option in either the old or new usage report, we get a 'request build permissions' message, even when admin on the workspace, and after having taken over the dataset. Access request comes through to me after taking over, but I can't grant access, as I get the same permissions. The dataset does not display on the workspace, in either lineage or list view (unless the report has been saved to a different workspace). We can only access settings by navigating to Settings > Power BI Settings > Datasets > Usage Metrics Report. The dataset for the old version (Report Usage Metrics Report) doesn't appear here at all. While we can control certain settings here, we cannot control access to build off the dataset. The message below indicates that we should be able to edit these settings, but if the dataset doesn't appear in the workspace, this is going to be difficult for users: If I switch from the new to old, or old to new version, both reports appear in the report selector. If I then use these, the 'New report usage off' switch can be in the wrong place, toggling it then causes the report to close. Repro steps: Open the usage report Click the 'New report usage off' to open the other version Use the report selector to switch to the first report opened Click the 'New report usage off' switch again Report closes unexpectedly

TSami · ‎05-31-2023

Since the first day of opening up the Admin Monitoring workspace, the datasets included there have been failing. For the first day, the Feature Usage and Adoption has failed and after couple of successfull days, the Purview Hub has now also failed. Both have their scheduled refreshes stopped due to constant failures. Since this workspace is totally out of my control even as Power BI Admin, I can't see anything that I could do to fix this. Can't even delete and get it recreated. Could this be somehow linked to the fact that we use admin accounts which need e.g. the Power BI Admin role to be activated?

SMHolck · ‎09-01-2022

I upgraded a workspace today to check out the new Multiple Audience experience. This impacted EVERY workspace/app in my organization and there is no way to switch back! Unfortunately, I see there are a lot of open bugs with this experience that may cause serious issues for app publishers within my tenant! Can you please provide ability to switch back the organization away from the Preview? Can you provide ability to switch back individual workspaces?

Nexter · ‎05-15-2023

The Chilet Slicer has started forcing the showing of tooltips with no way to configure starting. This began out of nowhere last week. This is especially bad since not all of my dimension field column names are configured to be viewed publicly. Any help would be much appreciated.

KyleTaylor · ‎02-19-2023

In the latest version (Version: 2.114.664.0 64-bit (February 2023)), all display boxes in PBI desktop aren't displaying correctly. Is this happening to other users? I can find an area to post to Microsoft. Some examples attached.

tzubenigni · ‎02-20-2023

The text on buttons in the Power BI Desktop show as wrapping, but does not wrap when viewed on the Power BI Service. I compared the properties of the buttons in both the Desktop and Service, but did not see any differences. Did a recent update change how button text renders in the Service?

GWerling · ‎06-19-2023

Starting with the May 2023 update, and continuing with the June 2023 update, on a remote device I use to create reports, I am prompted to login every time I open the app or a report. And once I do login, I am re-prompted to login immediately after. I am able to close the login pop-up at that point and can begin working. After I close the app, my login info is not saved and I am prompted to login again when I reopen the app or a report. If I open a report, after logging in, and open a 2nd report, I am re-prompted to login yet again. I am able to create/update reports once I get past the login every time, but it is extra time and annoying to be prompted to login all the time. I tried uninstalling and reinstalling several times, and issue exists. I even cleared out the cache folder that is setup under my Windows profile, but no help there. Installing the May/June 2023 updates on my local device works fine without issues. The problem is only occurring on my remote device with the May/June 2023 update. I have reviewed several similar issues like this that has happened with older versions of the desktop app, but I do not recall seeing anything recent. And all the older issues have been resolved with a new update. I was hoping this release would have resolved the issue this time, but it has not. Update: July 2023 Update is also reacting the same way.

skillbox · ‎06-08-2023

Several massive reports in PBI receive error message: "<ccon>DataSource.Error: ERROR [HY000] [Microsoft][BigQuery] (100) HTTP Error 400: invalid (Invalid page token, too short.).. </ccon>. The exception was raised by the IDbCommand interface. Table: ..." Tried also in power bi desktop - received same message, every time on a new table. need help

Share your ideas and vote for future features

Starburst timestamp(9) not supported date type in Power BI

Bug with September 2023 Version - DAX & CALCULATED COLUMNS NOT WORKING

Analyze in Excel (app)

BUG: "Formatting options are unavailable for this visual"

Publishing power BI broken when OneDrive refresh is toggled on

Power BI Dataflows not refreshing

Single Select Slicer in Desktop revert to multi-select

Alt+Enter behaviour - Alt shortcuts remain active

Publish to Web (public) generates embed code, but never displays

Admin monitoring refresh failure

Reports refresh erroring out

Test as role "not supported" message for composite model

Usage metrics report datasets broken

Datasets in Admin Monitoring workspace fail

Ability to switch back to the old App experience (non-Multiple Audiences) and individual workspaces

Chiclet Slicer now showing tooltip

Refresh popup messages (and others) not displaying correctly

Button Text wraps in PBI Desktop, but not in PBI Service

May 2023, June 2023, and now July 2023 prompts sign in every time the app, or a report, is opened

Power BI refresh from BigQuery - Error - Invalid page token, too short

Helpful resources

Subscriptions with PDF attachments not coming thro...

Can not change storage mode to Import or estabilis...

Datamart Field descriptions

Do I need another version of PowerBI to share a re...

Can no longer connect to Azure Data Lake Gen 2