Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
Im new to gateways and I got task to report data from table on sharepoint (ver.2013 foundation).
I cannot use sharepoint list, sharepoint online list or folder option
(the url to data is too long - and those 3 options want me to supply only root of the url, from which i cant get to desired data table)
so i used web option supplying url to that data table.
Report doesnt refresh with enterprise gateway, but refreshes succesfully in desktop Power BI.
Im getting this alert from Power BI service:
"Refresh failed: xxxxxx has failed to refresh"
{"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 cannot be used for the Web source. (Source at https://epodatelna.--------.cz/_layouts/15/wrksetng.aspx.)"}},{"code":"DM_ErrorDetailNameCode_Underl... Table: Table 0.
Thank you for any help.
Solved! Go to Solution.
We are kinda speculating here to rescue you through your issue as it is not really clear what the reason might be. However i can suspect a versions non compatibility along the process of refreshing your report. could be the sharepoint, the Gateway or the desktop.
So give it a last try and install a personal Gateway( your machine has to be 64 bits) in your computer and use it. If it works then the entreprise Gateway needs to be updated, else the sharepoint or your desktop.
Hope this will save you.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @Anonymous
Try to edit the Web credentials to Ananymous and None
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Tried Anonymous/None setting:
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":"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 cannot be used for the Web source. (Source at https://epodatelna.-------.cz/_layouts/15/WrkSetng.aspx.)"}},{"code":"DM_ErrorDetailNameCode_Underly...}}} Table: Query1.
Cluster URI: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 7a7e8d69-dcb6-41ed-b8f3-43f2132500f0
Request ID: 6f52e115-fb4d-0290-5066-f0453567454a
Time: 2020-07-01 14:50:10Z
Im confused, how is it possible that desktop version is refreshing without problem .. ?
also, thank you for suggestion.
The Power bi desktop is free and doesn't use Gateway to connect to the source.
The Power service might need a Pro license to achieve some requests.
Do you have a Pro license?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Yes, I do.
We are kinda speculating here to rescue you through your issue as it is not really clear what the reason might be. However i can suspect a versions non compatibility along the process of refreshing your report. could be the sharepoint, the Gateway or the desktop.
So give it a last try and install a personal Gateway( your machine has to be 64 bits) in your computer and use it. If it works then the entreprise Gateway needs to be updated, else the sharepoint or your desktop.
Hope this will save you.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @Anonymous
Happy that you solved your issue however can you indicate us which of the process that needed to be updated?
Thank you
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi,
I updated enterprise Gateway and Desktop PBI which leaves me only with not upgraded Sharepoint.
Our organization cant upgrade sharepoint.
So i cannot confirm that the problem is old sharepoint version.
Report refreshes only with personal gateway .. Unfortunately we would like to use enterprise gateway.
Hi @aj1973 ,
Would you please try to select OAuth2 as the Authentication method when configuring your refresh settings. Please confirm that you use the same credentials and privacy level like in Power BI Desktop and Service.
Best Regards,
Dedmon Dai
Hi,
I dont have that option in the dataset settings. its not sharepoint list or folder .. its web url dataset.
I know i should use those but , i cant to find the data with those other options, because those want me to use only root url and i cant navigate from root url to the data i want to report.
But if i use web url i can load data to report just fine.
To be more correct the Reply should be to @Anonymous .
Regards
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook