Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mphilips
New Member

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
v-huizhn-msft
Employee
Employee

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors