Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
pjmanuel
Frequent Visitor

List of power BI reports connected to ssas tabular model

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     

11 REPLIES 11
Icey
Community Support
Community Support

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.

datasource.png

 

And to decrypt, try this: Use the OData connector with the report server API.

datasource2.png

 

 

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
Frequent Visitor

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

pjmanuel_0-1648042266796.png

Should I need to active something on the server?

 

 

Icey
Community Support
Community Support

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:

Icey_0-1648087615147.png

Capture1.PNG

 

In other words, please make sure the api can return valid values.

api.PNG

 

 

Best Regards,

Icey

pjmanuel
Frequent Visitor

Hi @Icey great help thank you.
I got the data 

pjmanuel_0-1648112880439.png

and when I try to upload the data into PBI I get the follow message

pjmanuel_2-1648113029104.png

 

 



pjmanuel_1-1648112956447.png

 

 

Icey
Community Support
Community Support

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
Frequent Visitor

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

pjmanuel_0-1648205934959.png


thanks 
peter

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

lbendlin
Super User
Super User

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 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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