Forum Discussion

AlexEncuble's avatar
AlexEncuble
Regular Visitor
1 year ago
Solved

Change in Datasource Problem

We are planning to replace our Azure Analysis Services cube with a Semantic Model cube. I’ve run several tests, and everything worked as expected. Now that we’re in the final stage, I want to update...
Need Help
  • AlexEncuble's avatar
    AlexEncuble
    1 year ago

    Hi v-dineshya  Unfortunally it did not solve my problem. 

    I think I have to reshare the reports. 

    Thanks and Regards

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
1 year ago

Hi AlexEncuble ,

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

AlexEncuble's avatar
AlexEncuble
Regular Visitor
1 year ago

Hi v-dineshya  Unfortunally it did not solve my problem. 

I think I have to reshare the reports. 

Thanks and Regards

  • HarishKM's avatar
    HarishKM
    Icon for Super User rankSuper User
    1 year ago

    AlexEncuble Hey,
    If I have do it then I will follow below step to change data source.

     

    Step 1: Open the existing Power BI Desktop file that connects to the Azure Analysis Services (AAS) cube.
    Step 2: Go to the Home tab and click Transform Data to open Power Query.
    Step 3: In Power Query, go to Data source settings from the File menu.
    Step 4: Find your existing AAS data source, select it, and click Change Source.
    Step 5: In the Server box, replace the old AAS cube connection string with the new Semantic Model's server URL.
    Step 5: Test the connection and confirm it is working.
    step 6: Click OK to apply the changes.

    Note: I will make sure all column name are available and naming convention remains same as previous data.

    Now you have to published latest report and replace old report but take backup of old report incase we have to roleback.

     

    Pro tips: configure a app in your workspace for distribution so link remain same all the time - Publish an app in Power BI - Power BI | Microsoft Learn

     

    Thanks
    Harish M
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

     

     

    • AlexEncuble's avatar
      AlexEncuble
      Regular Visitor
      1 year ago

      Hello HarishKM ,

       

      Thank you, i know how to change the data source. The problem is, that if i do so and publish the report, than there are two reports with the same name.