how to set change the data source from sql to excel file?

Here is a video showing how to change from Excel to SQL - You can follow the similar approach to change from SQL to Excel..

 

Change Data Source of already Imported Table from Excel to SQL Server in PowerBI | MiTutorials (youtube.com)

Hi oakfootballclub ,

 

I’d like to acknowledge the valuable input provided by the miTutorials . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue. 

 

You can start by creating a new query to connect to a local Excel file. Then in the power query editor, copy its first few step codes into the SQL query to replace the first Source step. Don't forget to add a comma at the end of the last pasted step.

 

Sometimes the automatically generated ‘Change Type’ step does not change the data type correctly, you may need to adjust its code or delete it and change the data type manually to make sure that all columns have the correct data type before subsequent conversions.

 

Here are some more links for reference:

How To Change Data Source Of Existing Report In Power BI (c-sharpcorner.com)

How to Change Data Sources for Existing Power BI Reports - Iteration Insights

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.