Forum Discussion

latheesh89's avatar
latheesh89
Helper II
9 years ago
Solved

Update connection string for Imported PBIX file

Dear Techies,   I have to import PBIX files to multiple workspaces. Each workspace is pointing to diffrent Analysis Services DB and we have on premises gateway too. The Problem when I try to Import...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi latheesh89,

    Action that updates all of the connections strings in each data source only works for datasets that use direct query. We can not update the connect string for import mode. More details, please review this article.

    If you connect database using Direct Model, you can update the connections string by referencing to this thread. In addition, I personally suggest you'd better post the developer related cases to Power BI developer community. You will get more professional support.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi latheesh89,

Action that updates all of the connections strings in each data source only works for datasets that use direct query. We can not update the connect string for import mode. More details, please review this article.

If you connect database using Direct Model, you can update the connections string by referencing to this thread. In addition, I personally suggest you'd better post the developer related cases to Power BI developer community. You will get more professional support.

Best Regards,
Angelia

  • latheesh89's avatar
    latheesh89
    Helper II
    9 years ago

    Thanks Angelia

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi latheesh89,

      You're welcome, it's my honor to help you. Please mark the right and helpful reply as answer, so more people will benefit from here.

      Best Regards,
      Angelia