Forum Discussion
Help with Data Sources and Column Updates in Power BI Service
Hi Anonymous
Thank you so much for taking the time to respond and provide detailed guidance!
I appreciate your help.
I realize I may not have worded questions 1 and 3 clearly, so I’d like to clarify:
For Question 1, I wasn’t referring to refreshing the data. Instead, I wanted to know if it’s possible to change the data source entirely—for example, replacing the current Excel file with a different Excel file in the same report, without starting from scratch.
For Question 3, I did try refreshing the semantic model (as per your suggestion), but unfortunately, the new columns I’ve added to the Excel file (stored on a SharePoint page) still don’t show up in the dataset. Do you have any ideas on why this might happen?
The reports were created directly in Power BI Service using Excel (preview) from a SharePoint page as the data source.
Thanks again for your time!
Hi maraujo ,
Question1:
Since you are using Sharepoint Excel as a data source to create reports.
Changing the data source in the service is not supported.
You will need to download the report to local and open it in Power BI Desktop.
Change the URL path to point to the new Excel file by editing the data source settings.
Question 2:
Adding columns belongs to schema refresh, which is not supported by the Power BI service.
You need to download the report to local, display the added columns in Power BI Desktop by refreshing, and then republish to the service.
Data refresh in Power BI - Power BI | Microsoft Learn
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Once again, thank you very much for taking the time to help!
It looks like I will not be able to do do this since I cannot share this to a windows PC, oh well...
Thank you so much