cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Share your ideas and vote for future features

Suggest an idea
shabeer

Dataset refresh error on Service

Submitted on ‎07-06-2023 01:16 AM Submitted by on ‎07-06-2023 01:16 AM
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 ... View more
Status: Accepted

Hi @shabeer 

It’s a known issue . The engineers are actively working on this issue and I will come back with an update if there is any progress.

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
24 Comments (24 New)
ThePBIMaster

Power BI/M365 Outage UK

Submitted on ‎09-04-2023 01:59 AM Submitted by Advocate II on ‎09-04-2023 01:59 AM
Hi All,   Our gateway, datasets, reports etc have all disappeared from Power BI Service. Workspaces are either not loading or not viewable. I spoke to a Power BI administrator at another company and they are also experiencing similar problems. I also note that there is has been a spike in reported issues with M365. - https://downdetector.co.uk/status/microsoft-365/   Anyone else experiencing similar?   ... View more
Status: Delivered

Hi @ThePBIMaster ,

I'm glad to hear that your problem has been solved, please feel free to let me know if you have any more questions in the future!

 

Best regards,
Community Support Team_Binbin Yu

See more ideas labeled with:
  • Gateways
8 Comments (8 New)
Tiemen

Admin monitoring refresh failure

Submitted on ‎05-31-2023 06:20 AM Submitted by Advocate II on ‎05-31-2023 06:20 AM
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 ... View more
Status: Investigating

Hi @Tiemen ,

 

I found that there are users in other threads with a similar problem to your feedback, but it is not reproducible in my case, I will continue to investigate the issue and will feedback here once I have any progress.

Datasets in Admin Monitoring workspace fail - Microsoft Fabric Community

 

 

Best regards.
Community Support Team_Caitlyn

See more ideas labeled with:
  • Gateways
30 Comments (30 New)
benz_te

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

Submitted on ‎01-12-2023 10:32 PM Submitted by on ‎01-12-2023 10:32 PM
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   ... View more
Status: Accepted

Hi @benz_te ,

 

This is acknowledged as an issue. We have reported the issue and submitted it to the internal icm platform, No:360537118 . Engineers will do their best to resolve the issue. I will update you here if there is any progress , please be patient.

 

 

Best regards.
Community Support Team_ Caitlyn

 

See more ideas labeled with:
  • Gateways
21 Comments (21 New)
venal

DM_GWPipeline_Gateway_TimeoutError

Submitted on ‎04-29-2023 02:03 AM Submitted by Memorable Member on ‎04-29-2023 02:03 AM
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 ... View more
Status: Accepted

Hi @venal 

It’s a known issue . The engineers are actively working on this issue and I will come back with an update if there is any progress.

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
  • Gateways
27 Comments (27 New)
Imrans123

Issue - Cannot seem to edit DataFlows Settings on Pro Workspaces.

Submitted on ‎07-19-2022 10:31 AM Submitted by Super User on ‎07-19-2022 10:31 AM
Was wondering if anyone is facing this issue? For all my Pro Workspaces, I cannot seem to edit the dataflow settings as they're all grayed out.    They are going on about their pre scheduled refreshs properly as they should. I am also able to make edits in Datasets for pro workspaces. But cannot seem to make changes in pro dataflow. My Premium workspaces (via PPU) are working just fine.      ... View more
Status: Delivered

Hi @Imrans123 

Fix has been deployed. End Time: 07/23/2022 8:33 PM PST . Please check whether it is normal in your Service .

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
  • Gateways
36 Comments (36 New)
Karthikeyan_Jo

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

Submitted on ‎05-30-2023 04:57 AM Submitted by on ‎05-30-2023 04:57 AM
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) ... View more
Status: Accepted

Hi @Karthikeyan_Jo 

It’s a known issue . The engineers are actively working on this issue and I will come back with an update if there is any progress.

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
28 Comments (28 New)
GregMarbais

Data Load Failures and Reports Spinning

Submitted on ‎02-23-2022 06:36 AM Submitted by Super User on ‎02-23-2022 06:36 AM
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. ... View more
Status: Accepted

Hi,

There is a Service Outage/Degradation mentioned on the support page of the Power BI, so stay tuned:

vrobertqmsft_0-1645668599972.png

 

https://powerbi.microsoft.com/en-us/support/

 

I will update here once I get any information.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

See more ideas labeled with:
67 Comments (67 New)
Link0978

Unable to configure gateway connections for dataset

Submitted on ‎12-13-2022 09:39 AM Submitted by on ‎12-13-2022 09:39 AM
Hi, I am unable to configure gateway connections for dataset for a pbix report uploaded. I have created data source connections prior to uploading the file. All the 23 data sources are on-prem. When I tried to apply the gateway connections (all have green check marks), I got this error message: I also noticed this banner. The dataset does not have any cloud data souces:     Edit: @v-yetao1-msft  I originally just uploaded the pbix file to the web portal. The file was built using the Power BI Desktop RS Jan 2022 version. Then I tried to open the pbix file in the RS Jan 2022 and published to our P1 capacity-backed workspace. The issue persists.   Then I opened the file in Power BI Desktop Oct 2022 for powerbi.com version. I saved the file and published it again. The issue persists.   Some of the data source connections are also used by other reports without an issue. The other connections were created just for this report. The connections are consisted of SQL servers and file shares.   We have 2 windows 2016 VMs in a cluster to host the on-prem gateway. Version Aug 2022.       ... View more
Status: Delivered

Hi @Link0978 

This issue has been fixed , I will change it to "Delivered" .

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
  • Gateways
36 Comments (36 New)
ericmarshall

Unable to feed on-premises SQL-Server data into Lakehouse

Submitted on ‎05-27-2023 07:33 AM Submitted by on ‎05-27-2023 07:33 AM
Please advise specific instructions on how it is possible for data from an on-premises SQL server database to be fed into a Lakehouse. When using Gen2 dataflow to connect to on-premises SQL server via a gateway (client using Power BI Premium), configuring a Lakehouse as the data destination does not work: If I use a Gen1 dataflow to connect to the on-premises SQL server, and then reference the result of this dataflow using a Gen2 dataflow, interface (most of the time) allows for the Lakehouse to be assigned as the data destination, but then the Gen2 dataflow fails to refresh and gives the following error: When above dataflow is referenced in a pipeline, the associated run fails and below error message is received:   Trying to connect to the on-premises SQL Server database via a pipeline does not appear to be an option as the only available connection method is "Basic" and there is no option to select the gateway.   ... View more
Status: Investigating

Hi  @ericmarshall ,

 

Given that it is still a preview feature, based on the error message you provided, Power BI is currently not supported at this time.

vxiaoyanmsft_0-1685326994426.png

 

 

Community Support Team_Caitlyn

See more ideas labeled with:
3 Comments (3 New)
michaelsh

Dataflows very very slow Validating Queries

Submitted on ‎04-14-2021 04:38 AM Submitted by Kudo Kingpin on ‎04-14-2021 04:38 AM
Simple SQL query that runs 7 seconds in SQL takes 19 minutes(!) to validate in Dataflows 19 minutes!!!??? Not just one query. I've tried SQL Server and PostgreSQL - the time it takes to Validate is just crazy. What is going on? Please help ... View more
Status: New
See more ideas labeled with:
  • Gateways
46 Comments (46 New)
grrly

Error when processing the data in the dataset - DM_GWPipeline_Gateway_MashupDataAccessError

Submitted on ‎02-21-2023 08:54 AM Submitted by on ‎02-21-2023 08:54 AM
Greetings, I have been receiving this error message every day since 02/02/23 when trying to refresh our dataset. Similar error message, but different tables/dbs each time. PowerBI is connected to multiple access databases to retrieve calculated data. Has been running successfully for the last 3+ years.   Full error message today: Something went wrong. There was an error when processing the data in the dataset. Data source 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":"Unspecified error"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"388 SSC Dashboard DB Control ACH.accdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: tblControl_Score_SisterStore. Cluster URI:   WABI-US-EAST2-redirect.analysis.windows.net Activity ID:    21f8ec5e-0adb-409d-a7ee-ce91d17d30a7 Request ID:   dc551385-46a8-498b-b8ed-623de6e4d3a2 Time:            2023-02-21 15:02:50Z   Additionally, when checking all of our gateways, majority of them are showing as "offline". I have tried to resolve those to no avail: Error code:     GatewayUnreachable Data source error:   Gateway unreachable Cluster URI:    https://api.powerbi.com Activity Id:      b9db2528-0564-41a5-be56-c6f1e8607269 Request ID:     6e68fd9b-f9f7-40dc-9d40-a06d14231a3f Time:              Tue Feb 21 2023 10:26:45 GMT-0600 (Central Standard Time) Gateway on endpoint 'sb://wabi-us-east2-relay15.servicebus.windows.net/f484105f-e8ad-401c-ab33-25185fe178c5/' is unreachable. ... View more
Status: Investigating

Hi @grrly 

1.Could please let us know if you are facing the processing issue with only scheduled refresh or is it happening with on-demand refresh as well ?

2. Are you facing this issue with this only dataset or with other dataset's aswell?

3. Did you try to restart your gateway server ? What is your gateway version ?

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
10 Comments (10 New)

Error when trying to set up refresh schedule: Failed to load data sources. Please try again later.

Submitted on ‎08-01-2022 06:05 AM Submitted by Anonymous on ‎08-01-2022 06:05 AM
Hello,   After publishing a report, I try to set up a refresh schedule, and I receive the error below:   "Failed to load data sources. Please try again later."   I am using an on-premises gateway (personal mode).   Here are the error details:   Activity ID: fbaa47fb-bed3-497f-9c5f-629630eede0d Request ID: 71d6f731-dd38-fe2d-a671-354ffcd184a5 Correlation ID: 4697d43e-0e08-aff6-d80d-3045ed369aaa Status code: 500 Time: Mon Aug 01 2022 09:00:57 GMT-0400 (Eastern Daylight Time) Service version: 13.0.18756.45 Client version: 2207.4.12439-train Cluster URI: https://wabi-us-east-a-primary-redirect.analysis.windows.net/ ... View more
Status: Delivered

This issue has been fixed

See more ideas labeled with:
  • Gateways
35 Comments (35 New)
fgjerryjackson

Gateway Data Source Partially Online

Submitted on ‎02-24-2023 02:58 PM Submitted by on ‎02-24-2023 02:58 PM
Starting earlier this week, we randomly started having refresh failures on a dataset that was primarly using a Folder Data Source connection. After reviewing the datasource on the gateway, the Folder source shows being "Partially Online". When I refresh the data source status again, it will show "Online". I can then refresh the dataset on demand for a short time, but then it will default back to Partially Online after an extended period and fail the next scheduled refresh. Is this a known issue/bug?? ... View more
Status: Investigating

Hi @fgjerryjackson 

This is a new feature as part of the v2 gw/datasource status in GW Admin Portal. If there's a gateway member that's not online in a cluster (even though the cluster itself is online), we'll mark the gateway and datasource status as partially online. 

If you are having problems with the refresh, please provide details of the error message.

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
  • Gateways
6 Comments (6 New)
mhasan27

Dataflow Failing to refresh

Submitted on ‎07-05-2023 06:10 AM Submitted by on ‎07-05-2023 06:10 AM
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   ... View more
Status: Accepted

Hi @mhasan27 ,

 

We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

 

Best regards.
Community Support Team_Caitlyn

See more ideas labeled with:
2 Comments (2 New)
Martin_M

dataset refresh error

Submitted on ‎07-05-2023 04:22 AM Submitted by on ‎07-05-2023 04:22 AM
Hello Members, my dataset can't be refreshed, I get this error code: Unfortunately, I can't understand or research what that means. Does anyone have a suggestion for a solution?! Thanks in advance. M ... View more
Status: Delivered

Hi @Martin_M 

Thanks for your feedback ! I am so glad to hear that you found the workaround . I will change the status to "Delivered" .

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
  • Gateways
5 Comments (5 New)
TrevLc

DM_GWPipeline_Gateway_TimeoutError

Submitted on ‎05-11-2023 05:05 PM Submitted by Helper I on ‎05-11-2023 05:05 PM
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 ... View more
Status: Accepted

Hi @TrevLc 

It’s a known issue . The engineers are actively working on this issue and I will come back with an update if there is any progress.

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
  • Gateways
8 Comments (8 New)
hannibalmads

Issue with IBM DB2 connector October 2022 release of Power BI Desktop and the Power BI Service

Submitted on ‎11-07-2022 04:47 AM Submitted by Advocate II on ‎11-07-2022 04:47 AM
Since October 24th 2022 the Microsoft version of the IBM DB2 connector returns an error on both Import and DirectQuery when working with JDEdwards on an IBM DB2 database (I haven't tried with other databases and tables). "HISMPCB0002 In BasePrimitiveConverter the SetCodePage method has been called with a invalid codepage: 937"   This goes for the Power BI Desktop October 2022 version as well as the Power BI Service. When I roll back to the PBI Desktop September version I have no errors with my report. But when I publish the report to the service, the error reappears. Unfortunately this prevents us from doing any reports on the database. See also debate on Solved: Re: Error Message Trying to Hit iSeries DB2 - Microsoft Power BI Community which does not contain a solution even though it is marked as solved. ... View more
Status: Needs Info

Hi @hannibalmads ,

 

power bi desktop has been updated for November version, have you tried using the latest version? Can you connect successfully?

 

Best regards,

Community Support Team Selina zhu

See more ideas labeled with:
23 Comments (23 New)
Gatesi

There was a problem refreshing the dataflow. Please try again later. (Request ID: 1129fbbd-cca9-47b7

Submitted on ‎06-19-2023 09:49 PM Submitted by on ‎06-19-2023 09:49 PM
We have 8 separate Gen2 dataflows but they are all showing as a problem refreshing.    Data Gateways have been updated to the latest version (3000.178.9 June 2023), refreshes have been started run manually but its not working. These have refreshed multiple times previously.   ... View more
Status: Needs Info

Hi @Gatesi 

Is there a problem with manual refresh? What is the data source for these dataflows? Can you provide the error message for the refresh?

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
1 Comment (1 New)
RomBec

Dataflow refresh in the service is failing

Submitted on ‎07-25-2023 04:48 AM Submitted by on ‎07-25-2023 04:48 AM
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  ... View more
Status: Accepted

Hi @RomBec ,

 

Yes, you are right.

We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

 

Best regards.
Community Support Team_Caitlyn

See more ideas labeled with:
  • Gateways
1 Comment (1 New)
Idea Statuses

Helpful resources