cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
thatjoey20
Helper I
Helper I

Unable to download pbix offline file

Hello guys, 

Let me explain you my problem.  

So I have this lineage of my report

thatjoey20_0-1686661875857.png

 

The dataflow is connected in SQL Server VIEWs, that is already scheduled, so it is not DYNAMIC or DIRECT QUERY.

thatjoey20_1-1686662010901.png

 

These are my tables all in dataflow 

thatjoey20_2-1686662131368.png

 

And now my company wants me to edit some measures and import other things but I simply cannot download de pbix file. 

thatjoey20_3-1686662209014.png

 

It says i can't  download because it uses a live connection dataset. But how? If the data was all imported using SQL Server connection, that is not direct query? 

 

Can some one help me out?

 

 



1 ACCEPTED SOLUTION
collinq
Super User
Super User

Hi @thatjoey20 ,

 

The download options are to "get a copy" or to "live connection" - this is for the download and does not necessarily represent the report itself.  A report can be all import and when you download it you still have the option to live connect.  So, this is a choice for how you want the downloaded .pbix file to operate. 

That said, if one of the options is grayed out - as is your screenshot.  Then, there should be hover help as to why and there are some limitations on the types of downloads based on your admin settings and your permissions on that app/workspace/report.  

This article will be helpful in explaining those limitations and how to determine why the copy version of download is not available.

https://learn.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix#download-modes

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

2 REPLIES 2
aj1973
Community Champion
Community Champion

Hi @thatjoey20 
a Dataflow is not a Dataset and you can't download it that way. However you can create a Dataset out of your Dataflow

aj1973_0-1686665283892.png

 

There is another way to export your Dataflow in JSON format

aj1973_1-1686665464957.pngaj1973_2-1686665493914.png

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

collinq
Super User
Super User

Hi @thatjoey20 ,

 

The download options are to "get a copy" or to "live connection" - this is for the download and does not necessarily represent the report itself.  A report can be all import and when you download it you still have the option to live connect.  So, this is a choice for how you want the downloaded .pbix file to operate. 

That said, if one of the options is grayed out - as is your screenshot.  Then, there should be hover help as to why and there are some limitations on the types of downloads based on your admin settings and your permissions on that app/workspace/report.  

This article will be helpful in explaining those limitations and how to determine why the copy version of download is not available.

https://learn.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix#download-modes

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors