Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Change data source from SQL Server Analysis Services Database to Power BI Datasets

Hi, I have reports that have a live connection to a tabular model on SQL Server Analysis Services Database, and now I want to change the data source to use Power BI datasets. These reports have a lot...
Need Help
  • collinq's avatar
    collinq
    5 years ago

    HI Anonymous ,

     

    No, connecting to the dataset and then copy/paste is going to be your best bet.

    I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

MG86's avatar
MG86
Icon for Advocate II rankAdvocate II
1 year ago

For those coming here in 2024 or later, I figured out an easy solution to remove the current connection to AAS/SSAS:

1. At the bottom of PBI Desktop it states: Live Connection: Connected Make changes to this model

2. Click 'Make changes to this model'
3. Click 'Add a local model'

4. Click 'Submit'. A Direct Query connection will now be made.
5. Go to Transform Data > Data source settings

6. Select the DirectQuery to AS source and either hit the trashcan on the right or rightclick > delete. Confirm Delete.

7. Hit 'Apply Changes' in the bar that pops up above. There is now no data source whatsoever

8. Go to Get Data > Power BI semantic models

9. Choose a semantic model and connect