Skip to main content
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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Share your ideas and vote for future features

Suggest an idea
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)
sunnyleung

Data refresh through PBI Gateway keep prompting credential missing incorrectly

Submitted on ‎08-17-2020 07:18 PM Submitted by Advocate I on ‎08-17-2020 07:18 PM
While using PBI Service with on-premise data gateway connecting local excel files, the refresh keeps failed with "credentialMissing" error, however all credentials has already been given and verified (with a green tick next to the each data source shown under gateway connection), nothing can do...... ... View more
Status: New
See more ideas labeled with:
  • Gateways
33 Comments (33 New)

Recieved 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1

Submitted on ‎08-24-2021 04:18 AM Submitted by Anonymous on ‎08-24-2021 04:18 AM
Hey all,  Trying to refresh my datasets, but I've received an error:   Processing error: An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken='' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)' Cluster URI: WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net   Using PostgreSQL for Azure and using NO gateways.  This issue was faced before but no info on how it was fixed - https://community.powerbi.com/t5/Service/Could-not-load-file-or-assembly-System-Runtime-CompilerServices/m-p/1481902 Any ideas on how this could be fixed?  Thanks!   ... View more
Status: New
See more ideas labeled with:
15 Comments (15 New)
wynhodgkiss

DataSource.Error: SharePoint: Request failed: The underlying connection was closed: An unexpected e

Submitted on ‎12-08-2022 06:17 AM Submitted by Helper III on ‎12-08-2022 06:17 AM
"DataSource.Error: SharePoint: Request failed: The underlying connection was closed: An unexpected error occurred on a send."   Is there a known bug that has brought this error back? I am receiving variations of the above on all SharePoint connections in PBI desktop.    Desktop Version: 2.111.590.0 64-bit (November 2022) SharePoint in Microsoft 365 ... View more
Status: Delivered

We got the feedback from PG team

 

"After further investigate,Customer needs to work with their internal network team."

See more ideas labeled with:
  • Gateways
9 Comments (9 New)
ThuJa23

data gateway user mapping cannot be added after update

Submitted on ‎05-12-2022 01:29 AM Submitted by Advocate II on ‎05-12-2022 01:29 AM
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 ... View more
Status: Accepted

Hi @ThuJa23 ,

 

We have submitted to internal ICM 308260410 , engineers are doing their best to fix this issue, please be patient and I will give you feedback here once there is any progress.

 

As a workaround，you can try add ?newManageGatewaysUI=false In the address bar at the top of the manage gateway page.

 

Best Regards,
Community Support Team _ Caitlyn

See more ideas labeled with:
8 Comments (8 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)
rashidanwar

Schedule refresh sometimes fails for Google Sheets data source.

Submitted on ‎04-06-2023 12:12 AM Submitted by Helper III on ‎04-06-2023 12:12 AM
Dear members Hope that you all are doing great. I am writing here to resolve a google sheets connector error. Below is the detail. I would really appreciate any help in this regard. I have a report having various data sources. One data source is a google sheet connected through Power BI/Google Sheets connector. Sometimes scedule refresh fails to refresh the report and when I do a manual refresh it works. Sometimes manaul refresh aslo doesn't work. I started receiving these error recently. I think just a week or two ago.  Below is the error text. 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":"<ccon>Web.Contents failed to get contents from 'https://sheets.googleapis.com/v4/spreadsheets/1SFaLvXgIV0lYpSonpwCTw1Y7XCW9Rsws9_cQQVFb9oo?fields=sheets/properties,namedRanges' (429): Too Many Requests</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"GoogleSheets"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"https://docs.google.com/spreadsheets/d/1SFaLvXgIV0lYpSonpwCTw1Y7XCW9Rsws9_cQQVFb9oo/edit#gid=0"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Url","detail":{"type":1,"value":"https://sheets.googleapis.com/v4/spreadsheets/1SFaLvXgIV0lYpSonpwCTw1Y7XCW9Rsws9_cQQVFb9oo?fields=sheets/properties,namedRanges"}}],"exceptionCulprit":1}}} Table: dim_betterplaces gs_exchnage_rates. Cluster URI: WABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net Activity ID: 7286fe22-df00-4608-94df-ac6cc6200201 Request ID: dbd6c6e5-f5c5-4768-877b-f3e3f59ab855 Time: 2023-04-01 10:06:10Z  ... View more
Status: Investigating

Hi @rashidanwar ,

You got a 429 too many request error from the error message, it simply means that there are a lot of requests from the user’s end. When the requests are beyond capacity for the web servers, your browser will crash and display the code.  

I suggest you change the time of the schedule refresh, maybe there're other refreshes at the same time. Then, try to clear the browser cache.

 

Best regards,

Community Support Team_yanjiang

See more ideas labeled with:
4 Comments (4 New)
Cedricdij

dataset not refreshing

Submitted on ‎11-09-2020 04:27 AM Submitted by on ‎11-09-2020 04:27 AM
Hello,   Since this morning the dataset in PowerBI online isn't refreshing. when trying manual refresh it is not refreshing and we are getting this issue. We are using Postgres DB Version 11. Thanks for your help   Something went wrong There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these details. Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.0, Culture=neutral, PublicKeyToken=xxxxxxxxxx' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)'"}}],"exceptionCulprit":1}}} Table: Mission_Incoming. Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net Activity ID: xxxxxxxxxxxx Request ID: xxxxxxxxxxxxxxxx Time: xxxxxxxxx ... View more
Status: New
See more ideas labeled with:
  • Gateways
18 Comments (18 New)

May 2021 Gateway Error: SharePoint: Request failed: The underlying connection was closed.

Submitted on ‎05-21-2021 03:05 PM Submitted by Anonymous on ‎05-21-2021 03:05 PM
Some where around May 13th, all of our datasets that connect to SharePoint O365 started failing with the following message: Unable to connect to the data source undefined. (Details below). On May 16th we upgraded our gateway to the latest May 2021 gateway which was version 3000.82.2 (Maybe .4) and everything worked for a couple of days. Then on the 19th we noticed it was failing again. We noticed that the gateway download for May 2021 had a new release and was now at version 3000.82.6. So we downloaded and installed and it seemd to resolve the issue. However, we are still seeing it fail. This morning it failed, so then I was able to manually refresh and it worked, however, it just failed again for the scheduled refresh and a manual refresh is also not working. Ideas? Thoughts? What's going on? Not sure what to do.      Underlying error code: -2147467259 Underlying error message: SharePoint: Request failed: The underlying connection was closed: An unexpected error occurred on a send. DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.DataSourceKind: SharePoint Microsoft.Data.Mashup.ValueError.DataSourcePath: https://sharepoint.com/oursite Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net Activity ID: 0b95ab8e-3780-4df9-9af1-7d2edd5cfd55 Request ID: 1464c48e-1da5-ed3e-d5a3-956abbbc3971 Time: 2021-05-21 21:42:35Z ... View more
Status: New
See more ideas labeled with:
  • Gateways
22 Comments (22 New)
remy_guitton

Failed refreshes on reports merging data from on-premises gateway with sharepoint online

Submitted on ‎11-25-2020 01:30 AM Submitted by Advocate I on ‎11-25-2020 01:30 AM
Since this monday after upgrade to latest on-premises data gateway version, we get refresh failures on some reports with the following error message:        "Unable to connect to the data source undefined." Those reports were not modified and were working fine before gateway update. The issue can only be reproduced in a report mixing (ex: with a merge) data from both on-premises source and sharepoint online file. Reports sourcing both these data without any merge run fine. We cleared credentials, checked all connections were categorized as "Organizational" as advised on similar error message in other threads, but with no success.  Refresh is successful via Personal data gateway and when downgrading to previous gateway version, I don't get a successful refresh. I tried to apply the fix referenced on Power BI support page for some TLS/SSL issue but with no success, and this mention has disappeared from the portal since a few minutes: https://docs.microsoft.com/en-us/azure/security/fundamentals/tls-certificate-changes   Best Regards,    Rémy     ... View more
Status: New
See more ideas labeled with:
  • Gateways
15 Comments (15 New)
EugeniaBochko

Problem with Google data sources connection

Submitted on ‎11-18-2020 05:15 AM Submitted by Advocate II on ‎11-18-2020 05:15 AM
Hello! I have a big problem with data sources connection in PBI Desktop, especially WEB page from Google Spreadsheets. Today I come across with this problem with my existing data, I have been working for a year with these sheets and everything was OK: “The URL may be wrong or you might not have provided the right credentials to the server.” As usual I Publish to the web my online Google sheet) and then I get new Web data to PBI Desktop and nothing =(..I have an empty window. PBI displays: "We didn’t find any tables on this web page. No items selected for preview." http://prntscr.com/vlgucs  http://prntscr.com/vlguos Please let me know how to overcome this issue. ... View more
Status: New
19 Comments (19 New)
klinejordan

Unable to create new dataflow - just spins after hitting Next

Submitted on ‎10-12-2021 10:50 AM Submitted by Advocate II on ‎10-12-2021 10:50 AM
Since this morning we've had issues in our tenant creating new dataflows - after entering connection details and clicking next, the dataflow GUI just spins. There are no issues with the gateways as they are fulfilling refresh requests just fine. Was there a deployment for dataflows recently?  I'm in North Central US btw ... View more
Status: Investigating
See more ideas labeled with:
  • Gateways
20 Comments (20 New)
ocasares

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

Submitted on ‎10-02-2023 03:23 AM Submitted by on ‎10-02-2023 03:23 AM
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!.     ... View more
Status: Accepted

Hi  @ocasares 

It's a known issue , as @mrtstl mentioned , Microsoft team is working on this issue, please wait for the issue to be fixed, thank you!

 

Best Regards,
Community Support Team _ Ailsa Tao

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

Gateway - Refresh Problem

Submitted on ‎03-23-2020 06:46 AM Submitted by Anonymous on ‎03-23-2020 06:46 AM
Hello Guys,   I'm facing a huge problem about refreshing my dashboards on the app.powerbi. The gateway system is not working well and he is showing the follow screen:   Data source error{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the MySql source are invalid. (Source at {myip};{mydataset}.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"{myip};{mydataset}"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"MySql\",\"path\":\"{myip};{mydataset}\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: {mytable}. Cluster URIWABI-BRAZIL-SOUTH-B-PRIMARY-redirect.analysis.windows.net Activity IDaa5db203-4ab4-4d01-babb-797232d210f6 Request IDe4df98e9-9a18-fe52-ad70-fa6cb2b4f567 Time2020-03-23 13:33:21Z   Which is wierd because I can refresh on my power BI desktop with no problem.     ... View more
Status: New
See more ideas labeled with:
10 Comments (10 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)
noneother

Paginated report not navigating past the first page

Submitted on ‎08-08-2022 12:43 AM Submitted by on ‎08-08-2022 12:43 AM
Hello My existing published paginated report no longer allows me to navigate past the first page. I have not modified these reports and have no error messages to alert me to what the issue could be.   Picture below, when published to the pbi.com page navigation does not allow me to navigate past page 1. This is despite being able to do this within the report builder desktop app used to build the report. Furthermore, the pbi.com report indeed loads all the data as I can see exported PDFs/XLS showing the full report. Does anyone know why this could have occurred? Did MS roll out any recent changes? ... View more
Status: Investigating

Could not reproduce it in my side as far as my test. The paginated report works fine in Power BI Service.

 

Thanks for @MikeWall  provided information that it has been acknowledged as a bug by MS, and we will still continue to investigate this issue, if there is any progress, would update here.

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
14 Comments (14 New)
drvi

virtual network data gateway issue when adding data sources

Submitted on ‎08-04-2022 05:56 AM Submitted by on ‎08-04-2022 05:56 AM
I have deployed a virtual netowrk data gateway successfully. I am trying to add a SQL data source. Nothing happens on the page when I save it.  In the browser console i see errors.     ... View more
Status: Delivered

The issue has been fixed.

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

Snowflake Connector in Power BI Desktop not showing Information Schema

Submitted on ‎09-14-2023 12:52 PM Submitted by on ‎09-14-2023 12:52 PM
I have a user that is trying to connect to SNOWFLAKE in Power BI Desktop through the built in connector. They are not able to see the INFORMATION SCHEMA but can see everything else.   They have connected to snowflake in Power BI Desktop through ODBC and it works fine. The built in snowflake connector does not show it for some reason.    We want users to use the connector so they can use it on the webservice without the need of a gateway. The only work around currently is they recreated a view of the schema and can see it, it is just an unnessecary and redundant step it feels like.    Any ideas on how to fix this? ... View more
Status: Investigating

Hi @aleckealey18 ,

 

Please try updating Power BI Desktop to the latest version. Alternatively, you could try using a different connector, such as the ODBC connector that the user has already successfully used, or a third-party connector that is compatible with Snowflake.

 

Best Regards,

Community Support Team _ Neeko

See more ideas labeled with:
2 Comments (2 New)
Idea Statuses

Helpful resources