Forum Discussion

MaSo's avatar
MaSo
Regular Visitor
2 years ago
Solved

Multiple same data sources in 1 composite model

Hello,   This is my first post, i hope i have the good section 🙂   I have multiple SSAS datasets and PowerBI datasets which are publised to PowerBI online. I create a new dataset by connecting t...
  • sayaliredij's avatar
    2 years ago
    • It should be fine because, in the background, it's accessing only one table that was selected at the time. Therefore, even though you can see more processes related to one dataset, they are interconnected.

    • If you want to view only one dataset for all the tables related to it, follow these steps when adding a new table:

      1. Instead of creating a new source through "Get Data," click on "Data Source Settings."

      2. Within the Data Source Settings, click on the intended dataset.

      3. Click on "Change Source" and select the dataset again.

      4. Now, while selecting the tables, include all the required tables from that dataset.

    By following this process, you will have only one dataset, and it will encompass all the necessary tables.

     

    Thanks and Regards,

     

    Sayali

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful!!