Issues

Jlindsey00 · ‎02-26-2024

Since the Power BI Feb 2024 release, all of the reports in our workspaces have had this SSL error: "The server name provided does not match the server name on the SQL Server SSL certificate ... " Everything was working fine and then all of a sudden this error showed up across our workspaces Some notes and highlights: We use Azure sql databases No credentials were changed before this error occured and none have changed since I have double checked the credentials and the server names match both in the desktop and in the service The error occurs both on desktop and in the service We connect through a sql privatelink (servername.privatelink.database.windows.net) and use a VNET data gateway That gateway has not changed We tried disconnecting from the VNET data gateway and using an on-prem gateway, no luck connecting either We can connect to our Azure sql dbs with any other method directly in SSMS through excel In web apps we use Any idea what could be going on? Thank you!

Anonymous · ‎01-12-2023

I noticed when I published a report with an on-premise data source (SAP BW) along with cloud data sources (Sharepoint), the Apply button is greyed out in the gateway connection settings: Again, this is only applicable to newly published datasets. For the existing ones, there are no errors, and I can refresh successfully. Like this one, it has actually the same setup, just published in a different workspace some time ago: I just experienced this yesterday. Any of you are experiencing it now? Appreciate the responses! EDITED-- Check out the comments for the workaround Microsoft has also posted the issue on the Power BI Support page. Expect the fix to be on 24th of January

GregMarbais · ‎02-23-2022

Ever since about 6am Eastern today, my dataset refreshes have been failing and the reports are just spinning - no errors, just spinning like it's trying to load the data.

shabeer · ‎07-06-2023

Hello Team, My Power Bi dataset is not getting refreshed from yesterday. I have found out the issue is with Dataset that contains the Power Bi Dataflow (Legacy) connection sources. It is throwing the error as "Access token has expired, resubmit with a new access token.". However, there is no issue when we go ahead with Power Bi desktop refresh. The issue is not only with one dataset. The issue reasons are changing time to time. The same datasets were OKAY till yesterday evening GST. Attaching the error messages for your reference. Best Rag, Shabeer M P

venal · ‎04-29-2023

Most of the datasets are failing and shows an error - DM_GWPipeline_Gateway_TimeoutError. Can anyone facing similar issue with the latest version - 3000.170.8, Is it something like global issue

Karthikeyan_Jo · ‎05-30-2023

Power BI Desktop Version: 2.117.984.0 64bit(May 2023) When I try using Power BI Desktop Shortcut by Shift+Right click different user, It was previously working for me to login using different account. But recently I have updated the Power BI Desktop software(May 2023), after that I have getting below error, Kindly help on this. Unable to sign in Sorry, we encountered an error while trying to sign you in. Details: Unknown Status: Unexpected Error: 0xfffffffff80070520 Context: Unexpected exception while waiting for accounts control to finish: '(pii)' Tag: 0x1f7d734b (error code -2147023584) (internal error code 528315211)

TrevLc · ‎05-11-2023

Most of our datasets are failing with the error DM_GWPipeline_Gateway_TimeoutError Here are some detailed logs of one of the failures Data source error: {"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: XXXXX. Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net Activity ID: 102863cf-9705-4230-8356-90c55b612706 Request ID: 5b83fab5-5fd3-496f-abc3-d3214466f572 Time: 2023-05-11 15:01:26Z

Anonymous · ‎01-03-2023

Hello, While I have been using PowerBI Pro for months, I have never find this kind of issue, so I'm asking you in order to understand what could be wrong and fix it as soon as possible. Some days ago the automatic scheduled refresh in one of our reports is not working after several attempts (while it's working fine in the desktop version). The error message is the following: Data source error: {"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Jade Private. Cluster URI: WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net Activity ID: 83f3306d-0a91-4c00-a3d4-5f74c321c1c5 Request ID: 5d5ef067-af83-a85c-91b1-f64497119c58 Time: 2023-01-03 10:58:02Z I have tested almost everything I know it might impact, but the problem remains. Why can be this happening? Thanks in advance for your support, Juan Carlos Fernandez

TimoRiikonen · ‎06-02-2022

One of our clients said that his Power BI report stopped working yesterday. I wasn't able to find out what was wrong, so I asked him to send the report to me for testing. After the testing I have identical problems that he has: - Issue is not connected to any company: we have laptops from different companies and use different networks - Source system is (has been) always Power BI Desktop - Destination is any data source that needs Microsoft Azure authentication - After we used this problem report, the same problem is with other reports - Rebooting laptop doesn't help - Reinstalling Desktop doesn't help - He uses 2022-04 Desktop and I use the latest, so the version doesn't matter - On first attempt I got a list of my Microsoft accounts. But I was unable to select any of them and had to cancel it. We both have multiple accounts. - After that when we try to log in with Microsoft user account, we get a screen on the display, but it stays so short time we can barely see that there was something at all. Impossible to read it. - I am unable to use any of my Microsoft accounts now, so I can't develop to other clients either. - Error text: We're unable to connect. Please delete your credentials and try again later. - Global credentials have been wiped clean on Desktop reinstallation and local creadentials can't be the issue. - We are not using gateways, I just chose it because it is compulsory field. I have tried to Google how to cleanse away everything that looks like a cached Microsoft account, but so far no luck with that.

RomBec · ‎07-25-2023

There has been a dataflow refresh problem that started on 2023-07-01. Some Dataflows that contain SharePoint data sources randomly fail to refresh (sometimes the refresh works and sometimes is does not). The error messages can be different. The most recent one was: Error: Encountered user gateway exception: '[GatewayPipelineErrorCode]=DM_GWPipeline_Client_GatewayUnreachable [ErrorShortName]=GatewayUnreachableException/CommunicationObjectFaultedException[HResult=-2146233087] [ExceptionErrorShortName]=GatewayUnreachableException'. RootActivityId = debae686-23e3-4ec2-8c69-37c87fb9ad03.Param1 = [GatewayPipelineErrorCode]=DM_GWPipeline_Client_GatewayUnreachable [ErrorShortName]=GatewayUnreachableException/CommunicationObjectFaultedException[HResult=-2146233087] [ExceptionErrorShortName]=GatewayUnreachableException Request ID: 6eb5f485-f9eb-4b39-8f86-4c3e53ea95a3. Very often I also got the “An existing connection was forcibly closed by the remote host.” error. Maybe the issue I’m facing is related to the problem described here: Unable to read data from the transport connection: An existing connection was forcibly closed by the

deepakbhardwaj · ‎10-04-2022

When creating a dataflow in power BI Service, not able to save the dataflow. Following is the pop up which I get as error: Any inputs are welcome.

Anonymous · ‎08-24-2022

Folder permissions defined in the on-premise gateway stopped working yesterday (August 23rd) I am migrating all content between tenants - and dataflows that have been working for more than two years, all have the same issue in both tenants. Dataflows still refresh, but show issues when editing (invalid or missing credentials) Simultanuously the gateway settings on dataflows seem to be moved elsewhere The occurs when multiple files are referenced in the same folder In this case the first one "Servers" is working, using folder permissions The second is not working (anymore) but it is in the same folder - it is not working because it uses the same connection This must be a bug that has been introduced When trying to connect it finds the folder permissions, but the connect does not work Editing the connection with the correct user/pwd also does not seem to store the input, and there is no way to make it work again However, a workaround is possible, when adding File type permissions to the gateway It sees this as a different connection, and this can also be used once in that dataflow This workaround of course makes no sense - if there are folder permissions, you would not need file permissions on top Also these dataflows have been running for years - I have only seen this issue appear since yesterday Any solution available?

Reetej · ‎12-02-2022

Hi, I have published a pbix file on PBI service platform. The datasource is a MariaDB datasource and is setup in import mode. After I publish, I am not able to see the Gateway Option for the dataset. Also, not able to see the Data Refresh option. I have configured the standard gateway and also the datasource is configured in powerbi service platform. Is this a bug? I checked documentation and MariaDB is fully supported by powerbi. Regards, Reetej

ThuJa23 · ‎05-12-2022

Hi all, After the data gateway management UI changes, I cannot add new users anymore in Mapping User field list, as the button SAVE is disable, stays always greyed out. And when I click cancel, then new user is not saved. Do you have any idea about this or how can I fix this? do we have any new limits for user list? Thanks for your all advises! Thu

mhasan27 · ‎07-05-2023

Hello Everyone, One of the dataflow which has all the source from SharePoint is failing to refresh since last week. I triggered manual refresh but it is failing with the same error with different table. Kindly suggest ways to resolve this issue. Follwoing is the error message: Error: An existing connection was forcibly closed by the remote host Request ID: 4ad4a72d-d4d0-43b6-8c46-2d402d1a3443 Activity ID: 96dcd502-4720-473d-97fc-be6936663e98

ocasares · ‎10-02-2023

Hi, From today, the access to the old Power BI Gateway UI have been removed. We can only access to the new PowerBI Gateway UI And, because of that, we have lost the capability to manage the users being mapped in the Analysis Services connection, to route requests from Azure AD users to the on-premises Active Directory ones, with which it is bases the RLS security of the Microsoft SQLServer SSAS. You can see that the mapping rules for the initial users appear correctly: But when scrolling down, all the rest of the mappings seems to disappear, leaving a blank space: Please fix this. The mapped users cannot be seen and therefore cannot be managed correctly anymore!.

andrecxl · ‎02-07-2023

i have been using on prem data gateway for years and it worked fine until 2PM yesterday (Feb 6) uninstalled, reinstalled, reconfigured data gateway but issues persist however, no issue when the same dataset is refreshed manually using power bi desktop Power BI Support team - can you please help? thanks

tlaresch · ‎04-09-2020

Given I have a Dataflow with one or more queries to data source A When I change the queries to use data source B And I remove data source A from the gateway And I go to the Gateway connection for Dataflow And I look at "Data sources included in this dataset" Then I should see that data source B is there (yes, no problem) And I should see that data source A is gone But I see data source A is still there And it has a green check mark When I look at the "Status" column for the selected gateway Then I should see the status is good But I see "Gateway or datasources not reachable" When I look at "Data source credentials" Then I should see a single line saying ODBC (admin has granted access, credentials are not required) But I see two lines, and the first line has an X in a circle ODBC (x) (admin has granted access, credentials are not required) When I hover on the circle, I see a message saying the data source may have been removed (which is the case) When I click on the Settings gear ("Manage Gateways" on tool tip) icon under "Actions" for the gateway, the browser goes into an infinite loop loading two pages, where one of them has this URL: (I replaced my GUIDs with XXXXX - this is not the actual URL) https://app.powerbi.com/groups/XXXXX/settings/dataflows/XXXXX My data sources are 64-bit ODBC, but I am doubtful that should matter.

twintrbl · ‎08-31-2022

In the data hub, it says if you click on the column headers, it will sort that column. However, when I click on them, it does nothing at all. I can hover over the column name and see a gray bar, but clicking on it does nothing. This happens in Chrome and in Edge. It happens in normal mode and in Incognito mode. See screenshot for the gray column header bar (that does nothing):

swebster225 · ‎02-06-2023

Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net Activity ID: 9ed34d41-5f06-4248-96b6-6a42d072e5d3 Request ID: a2aec422-257d-3a99-4686-f88e16cbe3a0 Time: 2023-02-06 14:07:46Z Started a few days ago, most dashboards refresh fine, but any linked to SQL Tables aren't refreshing. I've checked our on prem data gateway, and rechecked the credentials and it is showing online, but I keep getting errors.

Share your ideas and vote for future features

Error in SQL server SSL Certificate Connection Since February '24 Release

Apply button is greyed out when adding a data source to the on-premise data gateway

Data Load Failures and Reports Spinning

Dataset refresh error on Service

DM_GWPipeline_Gateway_TimeoutError

NEW BUG: Version: 2.117.984.0 64bit (May 2023)

DM_GWPipeline_Gateway_TimeoutError

DM_GWPipeline_Gateway_TimeoutError

Suspicion: One Power BI report breaks Microsoft authentication permanently from Desktop to any servi

Dataflow refresh in the service is failing

Not able to save dataflow in power BI services

Folder permissions On-Premise gateway not working in dataflows

ISSUE - Dataset not discovering. Not able to see Gateway Options in the dataset

data gateway user mapping cannot be added after update

Dataflow Failing to refresh

Unable to map users in Analysis Service connection in the Power BI Gateway

refresh issues with on prem data gateway

Can't remove data source from Dataflow

Data hub columns don't sort

Error Refreshing Dashboard linked to SQL

Helpful resources

Power BI Embedded with DirectLake Dataset Error

Small multiple Y axis values disappearing

Publish to web url not working

Slicer bug?

TypeConversionFailure when not trying to convert