Forum Discussion
Power BI Datasets allow one dataset at a time.
Power BI Datasets allow one dataset at a time. I cannot add another dataset simultaneously. However, I can add other datasets when I do not use Power BI Datasets. But connecting data from any other cloud requires a database string and credentials and I want to avoid that. Is there any other better solution? Thanks in advance.
Hi Anonymous ,
The following live connection (multi-dimensional) sources can't be used with composite models:
- SAP HANA
- SAP Business Warehouse
- SQL Server Analysis Services
- Power BI datasets
- Azure Analysis Services
When you connect to those multi-dimensional sources by using DirectQuery, you can't connect to another DirectQuery source or combine it with imported data.
You could try to convert the connection into a DirectQuery as AlexisOlson mentioned.
Best Regards,
Jay
2 Replies
To connect to additional data, you need to convert the connection into a DirectQuery rather than the live connection.
Check out the documentation for this here:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-servicesHi Anonymous ,
The following live connection (multi-dimensional) sources can't be used with composite models:
- SAP HANA
- SAP Business Warehouse
- SQL Server Analysis Services
- Power BI datasets
- Azure Analysis Services
When you connect to those multi-dimensional sources by using DirectQuery, you can't connect to another DirectQuery source or combine it with imported data.
You could try to convert the connection into a DirectQuery as AlexisOlson mentioned.
Best Regards,
Jay
