Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all,
Someone knows, where I can get a list of power BI reports connected to ssas tabular models. In some PBI database.
the situation is I need to make a migration from ver 2012 databases, to v2016 and I need to check witch SSAS db is connected to witch PBI reports, to test them, if everything runs perfectly.
Thanks
Hi @pjmanuel ,
If your reports are on Power BI Report Server, you can try to get the ConnectionString from "dbo.DataModelDataSource" table in your report server database.
And to decrypt, try this: Use the OData connector with the report server API.
Hope this could help you.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Icey,
Great answare, But I got the follow error
Should I need to active something on the server?
Hi @pjmanuel ,
Please open your Report Server Web Portal. Then copy the URL and replace "https://<YOUR URL>/pbireports/" with the URL and delete the part of "browser".
For example:
In other words, please make sure the api can return valid values.
Best Regards,
Icey
Hi @Icey great help thank you.
I got the data
and when I try to upload the data into PBI I get the follow message
Hi @pjmanuel ,
Please check if resetting the data connection to re-enter credentials could work.
Reference: FIX: Power BI error Access to the resource is forbidden (windowsreport.com)
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Icey
One more time , thank you for your help.
I already reset my credentials , and when I insert my Windows credentials. I can see the data, in PQEditor, but ones I make apply I still have the issue
thanks
peter
Note: You tried to obfuscate the URL but only did it in the lower part. May want to take down the picture.
You posted in the Power BI Report Server section. Was that intended? The process is different between Report Server and Power BI Service. Please clarify.
Hi,
I'm using Report Server. To deploy my PBI Reports. And I change my compatibility , on my data tabular model,
and I would like to know how to get the list of the PBI reports are using that model , to figure out if I broke something.
Look at one of the views in the ReportServer database, for example the ExecutionLog3 view.
Hi,
ExecutionLog3 only have the execution, even don't have the any reference to the ItemID, that I can cross with the catalog. and the database is ReportServerPowerBI
that I can't find any reference to the data conection
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
5 | |
5 | |
4 | |
4 | |
3 |