Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
AnouarBen
Regular Visitor

Change Dataset location in powerBI cloud APP (app.powerbi.com)

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.

4 REPLIES 4
AnouarBen
Regular Visitor

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.

Hariharan_R
Solution Sage
Solution Sage

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

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


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

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors