List of power BI reports connected to ssas tabular model

[pjmanuel]

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     

[Icey]

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.

[pjmanuel]

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

Should I need to active something on the server?

[Icey]

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

[pjmanuel]

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

[Icey]

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.

[pjmanuel]

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

[lbendlin]

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

[lbendlin]

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.

[pjmanuel]

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.

[lbendlin]

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

[pjmanuel]

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