Forum Discussion
Refresh Power BI desktop file (with changed datasets) from Sharepoint
HI pbv,
I'm not so clarify for your scenario, can you please provide detail contents about this issue?
For example:
Original data source type, connection mode. detailed error message, screenshots.
Regards,
Xiaoxin Sheng
Hi Anonymous,
Thanks for your reply.
First scenario:
- I have created a Power BI desktop file (.pbix)
- I have uploaded one data source (Excel) (see figure 1)
- Figure 1
- I have uploaded this.pbix file on Sharepoint/Onedrive for Business
- From the Power BI Online environment I have uploaded the .pbix from Sharepoint (via "get data") to get a dashboard
- Every time I update the data source (and .pbix-file), I re-upload the .pbix file to Sharepoint
- The dashboard in the Power BI Online environment updates and everything is fine
Next step:
- I now upload two additional data sources (Excel) into my existing .pbix file (see figure 2)
- Figure 2
- I modify my .pbix file accordingly
- I re-upload my modified .pbix-file on Sharepoint
- I refresh my dataset/dashboard in the Power BI Online environment
- Now in my dashboard it shows errors (see figure 3)
- Figure 3
I also see that in the Power BI online environment the "dataset" has not changed after the refresh (it still only shows set 1, not set 2 and 3), I guess this is causing the problem?
HI pbv,
According to your description, your first excel data source is from sharepoint online or other online datasource, right?
If this is a case, you can use connection directly mode with onedrive refresh to handling refresh operations without setting up gateways.I guess you have added some on-premise excel datasources, right?
In this case, power bi need gateway to manage on-premise data source or mix datasources(on-premise and online) refresh operations.BTW, it seems like you pasted same snapshots.
Regards,
Xiaoxin Sheng