Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to connect data from (2) SQL Analysis Cubes and a CRM OData stream in PowerBI. I have tried:
- Using PowerBI online and recieve connection and credential errors
- Using PowerBI desktop and can only add (1) of the three sources, then it grays out the option to get more data.
I have been able to do this in Excel, however my end goal is to have a live data stream from all three sources.
Does anyone have any suggestions?
Hi @JParker,
Which data source did you connect to in Power BI Service, SSAS or Dynamic CRM online? If you connected to SSAS, please take a look at this article: Manage your data source - Analysis Services. If you connected to Dynamic CRM online content pack, check this article: Microsoft Dynamics CRM content pack for Power BI.
Based on my test in Power BI desktop, if we connect to a SSAS cube in "Connect Live" mode, "Get Data" button will be greyed out and we are not able to connect to another data sources. In your scenario, if you want to connect to two SSAS cubes and one Dynamic CRM online, you can connect to SSAS cube in "Import Data" mode, and connect to Dynamic CRM online use Dynamics 365 Online. See: Use Power BI Desktop to connect directly to your Microsoft Dynamics 365 (online) instance.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.