Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Execute PowerBI Script against two DB at Once

Fairly new users here.   I have a script that pulls data from two DB.     PowerBI is connected to both DB but as seperate Data Source.   How do I make it a single data source so the scripts can e...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Merge

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    While you can technically do that in Power Query it is not a recommended approach. It will be better if you load both data sources as is into Power BI and join them via the data model there.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Interesting, never thought of doing that. I will see how that can be done.