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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
nll14
New Member

Export report with semantic model

Hello, a collague has created a report using semantic model as data set. I am contributor and now owner of the data. I want to dowload the report to my desktop to make changes on data but when i download the file, data view does not appear.

How can i export the report and data set, querry view altogether to be able to edit?

nll14_0-1707155307025.png

no data view

6 REPLIES 6
Idrissshatila
Super User
Super User

hello @nll14 ,

 

yes, the thing is that this report is connected to a published dataset, so inorder to do changes in the data, you need to download the published dataset and do the changes then publish it again the refresh your report.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




amitchandak
Super User
Super User

@nll14 , Make sure you are downloading with an option, a copy of your data. Prefer to download from the file having the same name as the dataset(In case of import mode)

amitchandak_0-1707157480446.png

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I did.

I only see this option when i download the report file

If i download the semantic model, this "what do you want to dowlaod" queations, does not appear

@nll14 ,

 

because the semantic model is in another published report.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




could it be something related to settings?

i clicked 

nll14_0-1707158883853.png

but still no data view. I go to transform data and no queries appear either.

I go to data source setting on my report and i can see the semantic models it is linked to. the following options appear: 

nll14_1-1707158960335.png

and if i try to export the following appears: 

nll14_2-1707158981422.png

 

Any help on what this could mean?

Thank you

@nll14 ,

 

can you try finding the published power bi report that your report is reading from, it's totally different report that has a dataset and your power bi report is connected to this dataset.

 

check this to know what I mean https://powerbi.microsoft.com/it-ch/blog/connecting-to-datasets-in-the-power-bi-service-from-desktop....

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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