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
Puchert
New Member

Download a copy of report and data is greyed out, and dataset is missing in PBI Desktop

Hi Guys,

I have a report which is linked to a sharepoint excel sheet, I have the appropriate access to edit and download. I regularly update the sharepoint sheet which updates the PBI published report

I now need to make some changes to sync slicers which I believe I can only do when I download the .pbix and edit in the PBI Desktop application

When I click on the Download report function the option is greyed out

Puchert_0-1684305254311.png


If I choose the option with a live connection then I get the below error

Puchert_1-1684305375176.png

 

The connection obviously works and I have permission as changes I make to sharepoint today will update the visuals after the refresh.

When looking at the report lineage I can see the Sharepoint URL and that the connection is active

Any assistance to get the report downloaded would be appreciated

Thank you


1 ACCEPTED SOLUTION
Puchert
New Member

Hi Guys,

I solved this by accident when looking at another post

So the reason is that this created a loop, it was a live connection report which I published already

So after the download with live connection then just click on transform data in PBI desktop - most would be greyed out but there you can select the datasource and then do the required edits and republish

Hope this assists another Noob like me

View solution in original post

1 REPLY 1
Puchert
New Member

Hi Guys,

I solved this by accident when looking at another post

So the reason is that this created a loop, it was a live connection report which I published already

So after the download with live connection then just click on transform data in PBI desktop - most would be greyed out but there you can select the datasource and then do the required edits and republish

Hope this assists another Noob like me

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors