Save hard-copy of Power BI report with direct query model

[dkdirenzo]

Hi, is it possible to save a hard copy of a report in PBI Service which has a direct query semantic model? We need to save these daily and disable the automatic updates if possible.

[lbendlin · Accepted solution]

Sadly, yes.  Connect to the semantic model via SSAS connector and choose "Import"  rather than "Live".

I assume you are aware that this is a bit of a travesty. Hopefully you have good reasons for needing these hardcopies.

[Anonymous]

Hi @dkdirenzo ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you as Accept as Solution or sharing your solution. It would be greatly appreciated by others in the community who may have the same question

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[Anonymous]

Hi @dkdirenzo ,
We wanted to follow up since we haven't heard back from you regarding our last response. We hope the issue has been resolved.If the answer resolved your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful. Still needed any further assistance, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[Anonymous]

Hi @dkdirenzo ,
I wanted to follow up to see if you had a chance to review the previous response provided by us.If the response addressed your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.If you need any further assistance, feel free to reach out.

Thank you for being part of Microsoft Fabric Community Forum!

Regards,
Pallavi.

[Anonymous]

Hi @dkdirenzo ,
Thank you for reaching out to the Microsoft Fabric Community Forum about the issue you're encountering.

Yes, it is possible to save a hard copy of a report in power BI service with direct query. To get it, as @lbendlin mentioned, you may need to connect to the semantic model via the SSAS connector and choose the "Import" mode. By importing the data, create a static version of the report, which will not update automatically and allows you to save a hard copy of the report.

If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Regards,
Pallavi.

[dkdirenzo]

Hi, I'm not familiar with an SSAS connector. Can you provide more info on this?

[lbendlin · Accepted solution]

Connect to "Analysis Services" data source and then choose "Import"  and specify your DAX query.

[lbendlin · Accepted solution]

Sadly, yes.  Connect to the semantic model via SSAS connector and choose "Import"  rather than "Live".

I assume you are aware that this is a bit of a travesty. Hopefully you have good reasons for needing these hardcopies.