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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

0

Problem of Changing Live Conn to Power BI Datasets (Use Dataset Across WS Feature)

We tried to update the report datasets to Power BI datasets (Shared and Certificated feature is used) with PowerShell script but it does not seem to work for SSAS connections.

I mean, if I update the report dataset with Powershell script and save and close the power bi file before publishing the dataset to the cloud, the report dataset does not remember the changes that we changed it to Power BI dataset and it opens with the old version with original SSAS connection when I open the power bi file again. 

 

How I can handle dataset across workspace feature for SSAS live conn. datasets in PowerBI reports?

 

Powershell script query we used

https://webcache.googleusercontent.com/search?q=cache:uk20ykVV61cJ:https://powerbi.tips/2020/05/hot-...

Status: Delivered

Hi @FibaBI2019 

 

I got it. 😄 And thanks for your reply! 

 

Best Regards,

Community Support Team _ Caiyun

Comments
v-cazheng-msft
Community Support
Status changed to: Investigating

Hi @FibaBI2019 

 

May I know whether your issue is that the data source used by the pbix file doesn’t update after you removing original data source by PowerShell script and switching it to another dataset?

 

I’ve tested at my side. It works well. These are the tests I’ve made.

Test 1

  • Remove Live Connection to LocalHost SSAS in a report by PowerShell script and re-point it to a dataset in Power BI service(app.powerbi.com)
  • Save and close the pbix file
  • Reopen it, data source has been updated

 

Test 2

  • Remove the updated data source in Test1 by the script again
  • Connect to a dataset in another workspace
  • Save and close the pbix file
  • Reopen it, data source has been the dataset in another workspace

 

If there is anything I misunderstand, please feel free to let me know. Thanks.

 

Best Regards,

Community Support Team _ Caiyun

FibaBI2019
Regular Visitor

Hi ,

 

We checked step by step as you explained and realized that we misunderstood the concept.

 

Thank you for your support.

v-cazheng-msft
Community Support
Status changed to: Delivered

Hi @FibaBI2019 

 

I got it. 😄 And thanks for your reply! 

 

Best Regards,

Community Support Team _ Caiyun