How to change a data source for a Power BI file?

[tylerbauer]

How do you change the data source of a pbix file when you upload it into the Power BI service? I am trying to connect to onedrive but it seems OneDrive can only be connect through the web service and not the desktop version. If you created your reports on the desktop version, would you have to recreate the reports on the web version to access onedrive?

[Seth_C_Bauer · Accepted solution]

@tylerbauer You can connect from the Desktop, you just need to use the "web" datasource. Here is a walkthrough

[Seth_C_Bauer · Accepted solution]

@tylerbauer You can connect from the Desktop, you just need to use the "web" datasource. Here is a walkthrough

[tylerbauer]

Do you know if that works for the personal OneDrive or only OneDrive for business?

[v-ljerr-msft · Accepted solution]

Hi @tylerbauer,

Both OneDrive Personal and OneDrive for Business are supported. Here is a similar thread about connecting OneDrive Personal on Power BI Desktop for your reference. 

Regards

[tylerbauer]

Thanks for the link! That worked perfectly. I have a question about the data refresh capabilities. I know for the connection between OneDrive business and Power BI the data refreshes every hour. For the connnection you linked me to for connecting OneDrive Personal to Power BI, does the data refresh every hour as well? Basically, I want to make sure that the data refreshes correctly on the desktop file, on the online report when I publish it, and eventually in Power BI embedded. Thanks a ton!