cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
FMF New Member
New Member

Access to One Drive file denied with Blue Cloud Icon

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

Capture.JPG

3 REPLIES 3
mwegener Super Contributor
Super Contributor

Re: Access to One Drive file denied with Blue Cloud Icon

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.

 

Community Support Team
Community Support Team

Re: Access to One Drive file denied with Blue Cloud Icon

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 Super Contributor
Super Contributor

Re: Access to One Drive file denied with Blue Cloud Icon

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.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors