Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Does PowerBI Service support multiple DirectQuery data sources on one report?
We are facing a problem specific to SingleStore PowerBI Connector while we are querying data from two separate SingleStore databases via PowerBI. A single Power BI report with two DirectQuery connections to SingleStore does not work, but gives us an error message in each visual. Error message attached.
We can change one of the two SingleStore connections to use Import mode instead of DirectQuery and the problem goes away. This, however, is not a long-term solution as the data volume is already too large for Import mode refreshes to be practical, and it is expected to grow substantially in the near term.
We are familiar with composite models but unfortunately they won't satisfy our need because it implies usage of Direct AND Import modes. We’re interested whether PowerBI Service itself supports multiple DirectQuery connections, because PowerBI Desktop does. If it does, what are the differences between PowerBI Service and PowerBI Desktop that affect it?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @jchambers ,
Do you have data source credentials and gateways configured for both data sources?
Data refresh in Power BI - Power BI | Microsoft Learn
Best regards.
Community Support Team_Caitlyn