Access to One Drive file denied with Blue Cloud Icon

[FMF]

Hi,

I get the below error when Power BI service is accessing a file with "Blue Cloud Icon" status in One drive via Gateway

Unable to connect to the data source undefined.Please try again later or contact support. If you contact support, please provide these details.

• Underlying error code-2147467259 Table: 4G_RSLTE001.
• Underlying error messageAccess to the cloud file is denied.
• DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
• Microsoft.Data.Mashup.ValueError.DetailC:\Users\floferna\OneDrive - Nokia\xxx.xlsx
• Microsoft.Data.Mashup.ValueError.ReasonDataSource.Error
• Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
• Activity ID4ab782f0-d5b9-42db-b536-f1fd1c954e6b
• Request IDd12627a1-f686-b43b-dea4-fbe7e32d4acf
• Time2019-12-12 09:05:33Z

There is no issue to access the file via gateway when the status is changed to "Green Tick icon"..

Has anyone had a similar issue

[mwegener]

Hi @FMF ,

has your question been answered?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[v-xicai]

Hi @FMF ,

If your dataset not only contains cloud data source but also the on premise data source, then it needs to use the gateway and configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh .

Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @FMF ,

you point to a local path. "C:\Users\floferna\OneDrive - Nokia\xxx.xlsx"

So the gateway tries to access the local version.

The "Blue Cloud Icon" means there is a only a cloud version available.

Check this out:

https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.