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 All,
I have created a report in Desktop and published it to the service. I now want to schedule refresh my data, which consits of five web api call (no issue) and one xlsx saved locally on my PC.
I don't need the xlsx to update as its static information. However I need to update the web data.
I thought I could remedy this by publishing my xlsx to power bi and then changing my dataset in the service to the uploaded data set . However this does not seem possible.
I have also tried turning off the setting in desktop to not "include in report refresh".
What else can I do?
Thanks
Solved! Go to Solution.
Instead of sourcing from an Excel file use the manual data entry in Power Query. Copy/paste the Excel data into that data entry dialog.
Hi @emmjay
Thanks for reaching out to us.
You can use the method lbendlin said, if your excel file data is relatively large, you can save a copy, then connect Power BI Desktop to that copy, which will not be updated.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @emmjay
Thanks for reaching out to us.
You can use the method lbendlin said, if your excel file data is relatively large, you can save a copy, then connect Power BI Desktop to that copy, which will not be updated.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Instead of sourcing from an Excel file use the manual data entry in Power Query. Copy/paste the Excel data into that data entry dialog.
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.