cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mphilips Occasional Visitor
Occasional Visitor

Replace 'gateway connection' to 'OneDrive'

Hi all,

 

We have created a dashboard in Power BI Desktop. Our CSV data source is stored in OneDrive for Business. However the first time the data was added to the dashboard we user 'Get Data' and pointed to a synced OneDrive folder thus the path was C:\..etc. We update the source locatie to the OneDrive location. So far so good. We can easily overwrite the CSV in OneDrive and refresh the data in Power BI Desktop.

 

However, once our dashboard is uploaded to the Power BI Service the data source is recognized as a 'Gateway connection'. Thus auto renewing the data source is not possible.

 

How can we change the settings so Power BI Service will recognize the data set as 'OneDrive' and will automatically update when the CSV file is overwritten?

 

Thanks!

 

Mark

1 REPLY 1
Microsoft v-huizhn-msft
Microsoft

Re: Replace 'gateway connection' to 'OneDrive'

Hi @mphilips,

In Power BI desktop, you get data from file stored in OneDrive business through Get Data->file->onedrive path, rather than Get Data->Web->Type URL(like the methond in this article), right? If it is, you should save your .pbix file and store it in OneDrive for business, in Power BI service, select Get Date-> OneDrive for business->select the .PBIX file, you will see OneDrive refresh is enabled by default as screenshot below. When refresh dataset, it uses information in the dataset to connect directly to the data sources to query for updated data it then loads into the dataset. 

5.PNG

Please refer the the following threads and articles.

Power BI Desktop with One Drive Sync
Refresh a dataset stored on OneDrive or SharePoint Online

Best Regards,
Angelia

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 (Last 30 Days)