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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
OneWithQuestion
Post Prodigy
Post Prodigy

Change datasource from Analysis Services to Power BI dataset (connected to AS)

I want to use the shared Power BI datasets with my reports.

 

Right now they all connect to SSAS Tabular, but I want to make a shared dataset and then connect the dataset to SSAS and the reports to the dataset.

I can't change the connection for the existing reports that connect to SSAS.  I can change the SSAS server name but not the connection type.

Is there anyway to do this?

 

 

 

3 REPLIES 3
Greg_Deckler
Super User
Super User

If you are saying a Power BI Live dataset, not so sure, probably create a new one, connect it and copy and paste visuals.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Yes.

I have PBI reports that connect to SSAS Tabular.

I made a new empty report (dataset) that connects to that same SSAS Tabular server.

I want to update all my reports to use that new dataset that I published.

 

I was hoping I could just change the connection in the reports or maybe edit the report file's connection string, etc....

Good suggestion on making a new and copying over, I'll test that as well.

@OneWithQuestion 

 

As far as I know, it is not yet supported. To help improve Power BI, share feedback via Ideas.

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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