SharePoint data credentials accepted - but no data is loaded anyhow

[Anonymous]

Hi BI fam,

I am experiencing a weird issue. 

I have a dataset mixed with Sharepoint online & SQL sources. 

A few days ago i published my report and updated the SQL source with a gateway & logged in via OAUTH under data source credentials for the Sharepoint sources. All worked great. I enabled a daily refresh for the report because of the Sharepoint sources ( I run direct query on the SQL) so its a mixed storage mode report. 

Today i noticed that the data from the sharepoint sources are missing from my report. (some of them, the ones that are updated hourly, and written to a .csv file in a sharepoint folder). When i refresh on desktop, there is no issue, i load the data effortlessly. 

When i press "edit credentials" under data source credentials - i get a check mark that everything was applied succesfully, however i still have my X's under gateway, and data is still not loaded in the publish report. 

Has anyone experienced a similiar issue or knows where i might go wrong?

Thanks in advance

Best regards

Kristian

[v-xulin-mstf · Accepted solution]

Hi @Anonymous,

Please check:

Under Gateway Cluster Settings, select Allow user's cloud data sources to refresh through this gateway cluster > Apply

For more information, please refer:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Anonymous]

Hi, so i enabled the checkbox under my gateway - but the issue is still the same - do you have any further suggestions?

The credentials are also the same in the desktop file as in the online service... i re-created a report with only 1 sharepoint source and 1 sql source, but the problem still persists

[Anonymous]

Hi, 

Yea after a bit of reserch i figured this might be the problem, i dont own the gateway so i cannot verify yet - but have asked the admin to check the box 🙂 as for now ill accept your answer 

Thanks for your reply 

Best regards 

Kristian

[Anonymous]

A bit of clarification - 

If i refresh my report in desktop mode and publish it from here - there data from sharepoint is showing. 

The data only becomes missing when refreshing the point from the powerbi online services.