This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 11%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Hi Experts,
Is it possible to create a Power BI report from more than 1 SSAS Tabular DQ models ?
If yes please let me know the steps.
Thanks
Swapnil
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 41%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETL%3C/text%3E%3C/svg%3E)
You can add more than one SSAS Tabular model in a Power BI Report, but you cannot create New relationships because it is a direct connect to source. This limits the visuals to just one model. If you add measures or dimension attributes from unrelated table, then the results are going to be odd and not correct.
Power BI started something called composite models (mixing imported data with DirectQuery) but it is not completely support in most real world scenarios, yet. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
I am assuming that Microsoft is going to improve this in the future.
You might also want to read about Common Data Service and Certificated Data Sets in the Power BI service.
Thomas
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
They're actively answering Power Bi questions in dedicated forums here.
https://community.powerbi.com/
--please don't forget to Accept as answer if the reply is helpful--
I am asking about Power Bi report creation feasibility from more than 1 SSAS Tabular DQ Models, hence posted here
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Hi Swapnil,
Power BI report is a multi-perspective view into ONE dataset. So it could have only one dataset, we could not have multiple Tabular databases as datasource.
You could consider Power Bi dashboard which allows you to have multiple datasets. You could read :Dashboards for business users of the Power BI service to see the difference and limits in PowerBI reports and dashboard.
Regards,
Lukas
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi,
Have you resolved this issue ? Could we offer more possible help?