Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi there,
please I have a dataset that fetches data from an xlsx file in onedrive and then generates a report that I created in powerBI cloud APP (https://app.powerbi.com/), I would like to change it's location to a shared network,and then link the file to the existing dataset, I couldn't find a way change the data source in my dataset, currently the file is located in my local laptop, any ideas how I can achieve this,
Thank you.
Hello again @Hariharan_R ,
thanks again for the valuable support, unfortunately, the report was created directly on powerBI service, so we couldn't generate the PBIX file source file,we created a dataset from the xlsx file in onedrive and created the report from scratch in PBI service.
Hi,
If you have't created any parameter to hold the xlsx file path then you can't change directly on app.powerbi.com. You need to open the file in Power BI desktop and update the file path and publish it again.
As you will be referring the shared network, you need to make sure you configure the data gateway to access the xlsx file from app.powerbi.com
Thanks
Hari
Hi there,
Thanks for your answer, unfortunately I couldn't pull the dataset nor the xlsx file from powerbi Service, in order to modify it in PowerBI desktop, I couldn't find any download menu can you please refer me to a detailed walkthrough of some sort to do that.
Thank you.
Hi @AnouarBen
As a first step, you need your PBIX source file. if you are not able to download from app.powerbi.com then you might have stored in your local or reach the person who created. You can change the file path to something different when you have PBIX file opened in Power BI Desktop.
Thanks
Hari
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.