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
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
21 Comments (21 New)
TrevLc

DM_GWPipeline_Gateway_TimeoutError

Submitted on ‎05-11-2023 05:05 PM Submitted by 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)
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)
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)
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:
8 Comments (8 New)
Brains_86

PowerBI refresh DM_GWPipeline_Client_GatewayUnreachable

Submitted on ‎05-09-2023 11:55 PM Submitted by on ‎05-09-2023 11:55 PM
Hi all,  I have installed the latest on premises gateway and if I refresh online everything works smooth.  Except when I set the scheduled refresh on. I get this error:  Data source error: {"error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","pbi.error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","parameters":{},"details":[],"exceptionCulprit":1}}} Table: factuur_tags_tag. Cluster URI: WABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net Activity ID: 9250da6e-7976-4d65-97e7-6ea897359b6a Request ID: 3d42cb7b-cb2d-45d7-a1f2-a2dc31ee864f Time: 2023-05-10 05:16:59Z alle datasets are good and tested. As when I hit the refresh button manually the refresh is good.  Only when I want to schedule I get this error.  Van anybody help me further?  ... View more
Status: Needs Info

Hi @Brains_86 

Does scheduled refresh not work for all datasets ? If you roll back to a previous version, will scheduled refresh still report an error?

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
  • Gateways
2 Comments (2 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)
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)
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
5 Comments (5 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)
michaelsh

Dataflows very very slow Validating Queries

Submitted on ‎04-14-2021 04:38 AM Submitted by Continued Contributor 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)
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)
ChrisCrocker

"Failed to use the selected gateway"

Submitted on ‎12-16-2022 11:32 AM Submitted by on ‎12-16-2022 11:32 AM
Multiple people at my organization having this issue. The gateway (in green letters) says it is up and running. Here is the error message:   "Failed to use the selected gateway. Please make sure the gateway is up and running and try again." ... View more
Status: Delivered

Hi @ChrisCrocker 

This issue has been fixed , please check it in Service .

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
  • Gateways
12 Comments (12 New)
chriscooper71

BUG: VNET Gateway Issue

Submitted on ‎04-17-2023 12:06 PM Submitted by on ‎04-17-2023 12:06 PM
Standard PowerBI Gateway has no issues refreshing a dataset but when using the VNET Gateway we recieve this error:   Microsoft SQL: The size (8000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000).\r\nThe size (8000) given to the convert specification 'nvarchar' exceeds the maximum allowed for any data type (4000) ... View more
Status: Delivered

Hi all,

The deployment should be all completed now.

 

Best regards,

Community Support Team_yanjiang

See more ideas labeled with:
  • Gateways
59 Comments (59 New)
jenogrincha

Issues with Sharepoint authentication and export

Submitted on ‎04-09-2023 08:51 PM Submitted by on ‎04-09-2023 08:51 PM
Hello Support, hope you guys can help with my issues:   1. When trying to connect to Sharepoint folder, it throws "we couldn't authenticate with the credentials provided". I tried clearing the global permissions, uninstalling and reinstalling (March 2023 version from Microsoft Store), changing the sign in to be directed to edge and chrome but this error still persists. Asked my colleagues to try and they are having the same issue as well. 2. Is there any option to obtain the "Analyze with Excel" export option to a flat table instead of pivottable?   Thank you. ... View more
Status: Investigating

Hi @jenogrincha 

For the first issue , I found some similar cases , you can refer to them .

Solved: We couldn't authenticate with the credential provi... - Microsoft Power BI Community

Solved: We couldn't authenticate with the credentials prov... - Microsoft Power BI Community

Solved: Sharepoint authentication error "We couldn't authe... - Microsoft Power BI Community

Solved: SharePoint connection Error "We couldn't authentic... - Microsoft Power BI Community

Solved: SharePoint data - We couldn't authenticate with th... - Microsoft Power BI Community

 

For the second issue , with Analyze in Excel, you can create an Excel workbook containing the entire dataset for a specific Power BI report and analyze that dataset in Excel using PivotTables, Pivot Charts, and other Excel features . So if you want to export a flat table , Analyze in Excel does not meet your needs. You may be able to achieve your needs by exporting visual data.

 

Best Regards,
Community Support Team _ Ailsa Tao

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

Dataflows disappearing

Submitted on ‎10-31-2022 09:12 AM Submitted by Advocate I on ‎10-31-2022 09:12 AM
Hello,   All of our dataflows no longer appear in Power BI and subsequently, any dependent reports are receiving an error. The dataflows were hosted in premium (per user) capacity. It appears to have happened sometime between 9:00a - 10:30a CST.   We have some of the dataflows backed up and exported as .json from our disaster recovery documentation, but they do not reflect any recent changes. Has Microsoft acknowledged this issue, and can they restore the dataflows? ... View more
Status: Delivered

Hi @rflamenco 

I am so glad to hear that your issue has been fixed . I will change the status to "Delivered" .

 

Best Regards,
Community Support Team _ Ailsa Tao

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

refresh issues with on prem data gateway

Submitted on ‎02-07-2023 04:11 PM Submitted by on ‎02-07-2023 04:11 PM
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 ... View more
Status: Accepted

Hi @andrecxl ,

 

We have reported this issue and submitted it to the product team.
They have been aware of the issue and the engineers will do their best to resolve it. 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
5 Comments (5 New)
Reetej

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

Submitted on ‎12-02-2022 12:15 PM Submitted by Advocate I on ‎12-02-2022 12:15 PM
  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 ... View more
Status: Accepted

Hi all,

 

This is acknowledged as an issue.

We have reported the issue and submitted it to the internal icm platform, No: 353461347. 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
7 Comments (7 New)
powerbi-dev

Looking up invalid data on a dense spool

Submitted on ‎05-02-2022 05:44 AM Submitted by Advocate I on ‎05-02-2022 05:44 AM
I have a problem with a published dataset, with the error message "Looking up invalid data on a dense spool". It happens with a single measure and only in PBI Service. The dataset was fine and this suddenly started to happen. When I'm using PBI Desktop, there are no errors, but I soon as I publish the data and connect my report via Live Connection, any visual with the measure returns the error. The measure is quite simple, just a SUMX with a simple CALCULATE filter, and it's used in many other measures of the report which do not return any error message.   I have already tried: - Recreating the measure; - Republishing the dataset; - Deleting and republishing the dataset; - Creating a new file with PBIT template and connecting/   None worked.    If anyone has had this problem in the past, I'd appreciate some advice, thank you. ... View more
Status: Delivered

Hi @powerbi-dev 

The issue has been fixed , I will change the status to "Delivered" .

 

Best Regards,
Community Support Team _ Ailsa Tao

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

DM_GWPipeline_Gateway_TimeoutError

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

Hi @Juancarlosfm ,

 

This is acknowledged as an issue.

We have reported the issue and submitted it to the internal icm platform, No: 260356263. 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
11 Comments (11 New)
Idea Statuses

Helpful resources