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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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