topic Re: List of power BI reports connected to ssas tabular model in Report Server

List of power BI reports connected to ssas tabular model

Anonymous — Fri, 18 Mar 2022 14:47:59 GMT

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

Re: List of power BI reports connected to ssas tabular model

lbendlin — Sun, 20 Mar 2022 19:06:23 GMT

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.

Re: List of power BI reports connected to ssas tabular model

Anonymous — Mon, 21 Mar 2022 09:13:18 GMT

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.

Re: List of power BI reports connected to ssas tabular model

lbendlin — Mon, 21 Mar 2022 15:59:33 GMT

Look at one of the views in the ReportServer database, for example the ExecutionLog3 view.

Re: List of power BI reports connected to ssas tabular model

Anonymous — Mon, 21 Mar 2022 17:11:57 GMT

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

Re: List of power BI reports connected to ssas tabular model

Icey — Wed, 23 Mar 2022 09:10:43 GMT

Hi @Anonymous ,

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.

Re: List of power BI reports connected to ssas tabular model

Anonymous — Wed, 23 Mar 2022 13:32:48 GMT

Hi Icey,
Great answare, But I got the follow error

Should I need to active something on the server?

Re: List of power BI reports connected to ssas tabular model

lbendlin — Wed, 23 Mar 2022 12:56:46 GMT

Note: You tried to obfuscate the URL but only did it in the lower part. May want to take down the picture.

Re: List of power BI reports connected to ssas tabular model

Icey — Thu, 24 Mar 2022 02:14:14 GMT

Hi @Anonymous ,

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

Re: List of power BI reports connected to ssas tabular model

Anonymous — Thu, 24 Mar 2022 09:10:38 GMT

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

Re: List of power BI reports connected to ssas tabular model

Icey — Fri, 25 Mar 2022 02:49:44 GMT

Hi @Anonymous ,

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.

Re: List of power BI reports connected to ssas tabular model

Anonymous — Fri, 25 Mar 2022 11:01:12 GMT

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