Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts,
I have a Excel spreasheet that will located in sharepoint (it currently on My desktop) , and i have built a Report using this Excel spreadhseet.
I was wondering what the most efficeint way to Publish this report is, since the Excel spreasheet will be moved to sharepoint and updated manually every week? Thanks in advance
Solved! Go to Solution.
You can change the connection for this report this way, including putting the file on SharePoint.
The reason for doing this is the table that Power BI is using cannot be replaced with another table of the same name later. Power BI doesn't use table names internally, it uses numbers, so if "Sales" is table 10, if you remove Sales and replace with a new Sales, it might get an ID of 33, and no measures or visuals will work.
This article will help you do it step by step: See this article if you need help using this M code in your model.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou can change the connection for this report this way, including putting the file on SharePoint.
The reason for doing this is the table that Power BI is using cannot be replaced with another table of the same name later. Power BI doesn't use table names internally, it uses numbers, so if "Sales" is table 10, if you remove Sales and replace with a new Sales, it might get an ID of 33, and no measures or visuals will work.
This article will help you do it step by step: See this article if you need help using this M code in your model.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.