Issues

mmerchak

Our gateway is up to date (we just updated a few days ago) and I have been having this issue since the March gateway update. Random reports will frequently get this refresh error during it's scheduled refresh in Power BI service. This error is not consistent. For example, a 9:00am refresh completed without issue and then an 11:00am refresh failed with this error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<ccon>An error happened while reading data from the provider: 'Access to the path 'C:\\Windows\\ServiceProfiles\\PBIEgwService\\AppData\\Local\\Temp\\Microsoft\\MashupProvider\\Cache\\Uzd@iy7VOEcSTQNocKkMETMMCDlJeLNn+iocalJLh2WI=\\Cache.Key' is denied.'</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<ccon>rjc-sql3;BI_ReferenceTables</ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Safety Data. I have tried researching this error and have gotten nowhere. Does anyone know why this is happening/how to fix it? Thank you!

Element115

PBI Desktop Version: 2.128.952.0 64-bit (April 2024) ISSUE: 0__migrate on-prem source to LH and 2 DFg2. 1__make a copy of old pbix report. 2__connect to new LH data source, all tables in DirectQuery mode. 3__start relinking all visuals; all tables have the same name and schema as when the report was connecting to on-prem source in Import mode. 4__one slicer still using the same field name as before (field still selected and no error icon shows) appears as broken. 5__click on 'See details.' This is the error message that pops up: 6__remove field from data well; choose same field from Data pane, drag and drop it, and now the problem goes away. Another slicer picks up the change automatically and the above is not needed for this slicer. But another slicer next to it, same interface issue. Again, all tables are in DirectQuery mode.

spindive

Hello Fabric Team, We are seeing some inconsistencies when using the ROUNDDOWN function. For example, when creating a measure/calculated column with this hardcoded formula: (1.8-rounddown(1.8, 0))=0.8 The formula evaluates to TRUE, which is correct as 0.8=0.8 However, when we evaluate: (2.8-rounddown(2.8, 0))=0.8 The formula evaluates to FALSE, which in our opinion is incorrect as 0.8=0.8, no matter how we got there. Please see below for our test tables: On a call with the Fabric support team (ticket #2404220040008712), we tried and found that the same problem exists even when: We don't harcode the number and use references (columns, other measures) instead We use INT() or TRUNC() instead of ROUNDDOWN() We move the formula to Power Query and use Number.RoundDown instead We use strictly equal == or other operators like <= and >= Our current workaround is to put a ROUND on the left side of the formula, that seems to overcome the issue. Lastly, not sure if this will help you investigate, but we noticed that the breaking point is between 1.8 and 1.9. Where if the decimal number is below or equal to 1.8 the formula will work properly, while it will not work if the decimal number is above 1.9, with the following exception: For some reason, 1.99 and 1.9999 works (evaluates to TRUE), but 1.9, 1.999, 1.99999 and beyond do not. Looking forward to hearing back from you! Regards, Felix

zinchic

Is there a way to export to exce with going to the upper right (...)

Jerinfonterra

When mapping the aggregates to the detail table.. if the column name is long its not fully available.. is there any way to see it fully and map?

Lingaraj-Mishra

Hello Power BI Community, I am experiencing difficulty with authenticating API requests using the OAuth 2.0 client credentials grant type for the Power BI REST API. I am attempting to access the API at https://api.powerbi.com/v1.0/myorg/datasets, which requires authentication tokens that I am trying to retrieve via Azure Active Directory (Azure AD). Here is a breakdown of the steps I've followed: Application Registration: I registered my application in Azure AD, ensuring it has the necessary API permissions for Power BI (e.g., Dataset.Read.All). Token Request: I am using the endpoint https://login.microsoftonline.com/{tenant_id}/oauth2/v2.0/token for token generation. Here’s the curl command I use (with sensitive data omitted):curl -X POST https://login.microsoftonline.com/{tenant_id}/oauth2/v2.0/token \ -H "Content-Type: application/x-www-form-urlencoded" \ -d "client_id={client_id}" \ -d "client_secret={client_secret}" \ -d "grant_type=client_credentials" \ -d "scope=https://analysis.windows.net/powerbi/api/.default" 401 Unauthorized Error: Despite following all documented steps and verifying that the client ID, secret, and tenant ID are correct, I receive a 401 Unauthorized error when I attempt to use the generated token to make API requests. Here are some additional details: The application permissions in Azure AD include all necessary Power BI related permissions and have been granted admin consent. There are no alerts or incidents reported on the Azure status page that indicate an ongoing issue with Azure AD or Power BI services. Questions: Has there been any recent change to the authentication mechanisms for Power BI that might affect the client credentials flow? Are there known issues or maintenance activities affecting the OAuth 2.0 client credentials grant type for Power BI APIs? Could there be specific tenant configurations in Azure AD that might restrict or alter the expected behavior of the client credentials grant? Any suggestions on troubleshooting steps or alternative configurations that could resolve or work around this issue?

MattSwan

To recreate: Setup a dashboard and and a filter and tick Require single selection. Publish the report. On the published report you can untick the select item and the report will no longer be filtered. You can select multiple tickboxes and the data will filter accordingly. Perhaps what should be happening is the tickboxes changes from tickbox to radio buttons when Requires single select is ticked. In PBI Desktop On the Published dashboard.

Idrissshatila

I noticed and some users posted about that in the UI in Power query when using the filter on a column, the second box seems to be eaten, although it's not affecting any functionality but it should be shed the lights on for fixing in future release. This was seen in the latest April Release.

Hari

Hello, It was recently noticed that the Report folder in Admin Monitoring Workspace - Feature Usage and Adoption report has been removed from the dataset. I am now unable to obtain the report details. Could you kindly confirm whether the same may be restored, and if so, how the report folder be added? Missing Folder in Feature Usage and Adoption report dataset.

mwaltercpa

I was meeting at a co-workers desk, and wanted to show her our financials from my profile. We logged her out, and I logged in. Showed her the report from my profile, then went to log out, and 'forget' my profile. She went back into her own 365 profile, and we noticed that the Financial Statement had appeared in her 'shared with me' folder of reports. While RLS prevented her from seeing any figures, this concerns me. About a year or two ago, I ran into a very similar issue when logging in and out of accounts quickly. The issue that time had permanatly shared the cached report with the second user logged in. I beleive the fix had something to do with the cached profile not being fully purged before signing into the second.

mgast

Conditional formatting from PowerBI Desktop is not transferred to paginated reports. Regardless of whether the paginated reports were created via the BI service or the Report Builder. Does anyone know how to do? Regards Martina

iannedrs

I'm using Power BI Desktop on a daily basis because I have four dashboards that I update everyday (new data daily). Last Monday, April 15, I was able to access my files in the morning. Come afternoon when I was about to update another dashboard, I suddenly got this error: There is an error in XML document (1, 1). When I tried opening all my Power BI files, and even creating a new one, I still get the same error. I searched and most suggested to just reinstall Power BI, or delete the App Cache. I did both, but the error still persists. The weird thing now is Power BI is working fine (with my files) using a different user in my laptop: i.e. I was using my own user account (admin access) and my Power BI app is having an error, but when I logged on to a different user in the same laptop, Power BI is working well. How can I fix this issue? It's quite a hassle now logging in and out of my laptop user account just to use Power BI. Thanks in advance for the help!

ewohmot

Our organization has 5 PowerBi Premium User licenses and we are an existing O365 customer for email, office apps, teams, etc. Trying to publish reports/dashboards so our organization users (do not have a paid PowerBi license) can view and interact with. MS chat advised this should be possible via Teams connector. Unfortunately users get the message below when trying to access the report. Any help would be appreciated. "you've selected micosoft fabric free. we can't finish signing you up because Microsoft Fabric Free isn't currently available for your work or school"

rayishome

Feedback Type: Frown (Error) Error Message: The remote server returned an error: (500) Internal Server Error. Stack Trace: Microsoft.PowerBI.Client.Windows.PowerBIService.PowerBIServiceException at Microsoft.PowerBI.Client.Windows.PowerBIService.PowerBIServiceProxy.GetResponse[T](ServiceProxyRequest request, String callerName) at Microsoft.PowerBI.Client.Windows.PowerBIService.PowerBIServiceProxy.GetDatahubArtifacts(Nullable`1 pageNumber, Nullable`1 pageSize).....

rdnguyen

This seems to happen to existing dataflow when change saving is attemped. New dataflow is saved without any issue

Idrissshatila · ‎04-17-2024

Hello, We experienced a strange issue at the beginning of April. When clicking on the month of March, it displays April 1 underneath it. Additionally, when clicking on April, it starts from April 2. This problem is only occurring in April 2024, and the days are shifting 1 day backwards as you can see. the Power BI versions that we noticed this issue with are the Feb release and the April release, we didn't download the march release to check it on it. 1- When clicking on march 30, it's showing 30 and 31 2- When clicking on march 31, it's showing 1 April 3- When clicking on April 1, it's showing Blank I also tried to create a calendar for 2025 to see if it's also affecting and the result is that the error shifted 1 day backwards and now 31 march is blank and in 29 March is showing 29 & 30. The issue is shifted 1 day backward every year, since i also tried to see 2026 and 2028. We really appreciate a solution for this, since it's also Power BI Certified.

gfbentes55_sema · ‎04-16-2024

I'm having a problem creating a LAT/LONG coordinate map using a JSON WEB layer

swift_devon · ‎04-16-2024

When using appsource visuals I frequently run into an error where selected fields go blank in the build pane a white arrow appears to the left and then I get stuck in a loop of a something went wrong message. With the only way to get out of it being quitting via task manager.

brus4814 · ‎04-16-2024

Hi I have connected sharepoint file as one of the data sources to my pbix file. The file is expected to have dynamic columns. I'm using parameterization to bring those dynamic columns into my table visuals on the report. Report refresh works fine in desktop app and was working fine in power bi service until the April release. Refresh fails with this error in service: Data source errorThe 'xxxx' column does not exist in the rowset. Table: A. Could I please report this as a bug, thanks

ClaretBlue · ‎04-15-2024

I recently did my monthly data rfresh only to get below screenshotted errors. Can you assist. i have been looking around for a solution but am stuck. All the while everything was working fine. Please help with below errors. Seems Cache removal is noit a trick at all.

Share your ideas and vote for future features

Frequent "Cache.Key is denied" Refresh Failure on Service

BUG::SLICER::IDbConnection interface

Possible Bug with Rounding

export to excel

Is there any way to see the full name of the columns when mapping the PBI aggregates?

Issue with Client Credentials Grant Type for Power BI REST API Authentication

Multi-Select Possible in Filter Panel even when Require single selection is ticked

Power Query Filter Rows Basic UI bug

Admin Monitoring Workspace - Dataset has removed folder named "Report"

Report jumps between two profile logins.

Conditional formatting from PowerBI Desktop is not transferred to paginated reports.

Error: There is an error in XML document (1, 1).

Cannot share PowerBi reorts and dashboards to my organization.

Get External Data: Power BI semantic models throws a 500 error

Power BI Service - NetworkConnectionIssue when saving change to dataflow

Timeline slicer is showing 30 & 31 March under 30 March and 1 April Under 31 March

PROBLEM WHEN USE JSON FROM WEB WITH LATITUDE AND LONGITUDE DATA

Error when using AppSource visuals. "Something went wrong" Loop

Data Source error: Column not found in rowset

Dashboards

Helpful resources

Publish to web url not working

Slicer bug?

TypeConversionFailure when not trying to convert

filter pane values in service are showing in black...

Wrong french translation for "reader" permission