CODEWITHSUNDEEP
powerbipowerbi-datasource
Muflix
Muflix

Reputation: 6768

PowerBI Cloud - Access dataset from the SQL Server

In the company we have Power BI Cloud, which is already integrated into other system. I was wondering if we could take advantage of this integration and download data from Power BI Cloud dataset directly to our SQL Server (not the other way around, as is standard). Power BI would be the source of the data, and in that case SQL Server would be the client that would download the data. I found how to load PBI Desktop data to the SQL Server, but not how to use the PBI Cloud datasource. Is it even possible and if yes is there any documentation to that?

enter image description here

Upvotes: 0

Views: 195

Answers (1)

Murray Foxcroft
Murray Foxcroft

Reputation: 13745

A PowerBI implementation usually works the other way around, you use your infrastructure to prepare your data and get it in shape before consuming it in reports.

That said, you have a few options.

  1. As above, move your data prep and processing outside of PowerBI
  2. Use Azure Data Factory to perform your PowerQuery data prep steps outside of PowerBI
  3. Use the PowerBI XMLA endpoint. This requires the PowerBI premium cloud SKU.
  4. Download data manually with the PowerBI export options.

Upvotes: 1

Related Questions