Forum Discussion

kenyonca's avatar
kenyonca
Advocate I
9 years ago

Auto Refresh with multiple data sources

I am attempting to have my Power BI dashboard pull in data from multiple data sources and update the online dashboard autmoatically each night.   My first data source, SmartSheet, is updated daily ...
Need Help
kenyonca's avatar
kenyonca
Advocate I
9 years ago

Yes that is an option we have thought about.

 

Is there no way to just either save the 38,000 lines in PowerBI with the Enter Data.

That or to get Power BI web version to not pull from that particular data source on the auto-refresh? But only pull from the SmartSheet data? The desktop version lets you choose to not include certain data sets when you trigger the refresh but the web version doesnt seem to have this capability.

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

kenyonca,

 

Is there no way to just either save the 38,000 lines in PowerBI with the Enter Data.
Currently, we cannot do it by using Enter Data.

 

You could store your excel fiel to your Power BI group's OneDrive for Business. You can continue updating files you store in OneDrive for Business, and those updates are automatically reflected in the Power BI reports and dashboards based on the files. Please refer to the link below.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-connect-to-files-on-your-groups-onedrive-for-business/

Regards,

Charlie Liao