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.
Dear expert
I have one huge excel file in one power bi report, due to this report is covered sales from 2019 until current date, everyday when i run this report, it take very long time to uploaded. How can i section this excel report into 2019, 2020 ,2021 and saved into one folder without change any setting on the existing Power BI report and reduce the uploading time?
Please advise.
Thank you
Maggie
Solved! Go to Solution.
@Anonymous , Please find the file I tried. Sales was CSV , the text was the folder.The file is attached after signatures
cvs code in inside the comment /* */
Hello
I have a similar problem: when changing the path of data that is loaded into PBI, the error "Items blocked by errors with other queries are loading" comes out. I appreciate indications in this regard,
Best regards,
Hi, @Anonymous
Have amitchandak’s reply helped you to solve the problem?
To change the original data source to replace it with a new file or folder, there are two ways to in Power BI desktop:
Before updating your data source, you should first check if the column name and data type are the same as the columns in the original Excel file. If not, you will get an error.
Then you should update the reference of the next steps according to your actual situation.
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Would be a bit difficult. Create the folder source in anew source. Get the code from
Home Tab -> Transform Data ->Transform Data -> Right click on Table -> Open Advance Editor and take the top part of the code and place it in place of the old connection code.
keep back up of file
refer this video - https://www.youtube.com/watch?v=59PUFuuCrbY
I follow your instruction but it won't allow me to do it. The pop out screen as below:
Please advise.
Thank you
Maggie
@Anonymous , Please find the file I tried. Sales was CSV , the text was the folder.The file is attached after signatures
cvs code in inside the comment /* */
Covering 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.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |