Create SQL Server Linked Server for PowerBI-Dataset? Fire DAX Query from SQL Server to PowerBI.com?

Anonymous

I don't think you can create any so-called linked server to PowerBI.com, as there's no such "provider" for PowerBI.com. However, Power BI actually provides REST APIs to create dataset, push data, embed reports etc. The REST API also has limitation, there's no such a API to get data from a published dataset at this moment. You can check and vote this idea Be able to get a dataset's data via REST API up.

 

Backgound:
I need to consume data from a published PBI-dataset in R-Script. In R-Script there seems to be no possiblility to directly connect to DAX/PowerBI sources.

 

thanks Eric_Zhang, yes i think you are right, currently there is no possiblity as the needed MSOLAP.7 provider is not registered in sql2016. Also there seems to be a issue regarding SSO authentication for the provider:

https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-connect?hubRefsrc=email&utm_source=lfemail&utm_medium=email&utm_campaign=lfnotification

I will now connect via excel und integrate the excel as a linked server to be able to join onPrem-SQL with PowerBI data.

Ugly but working workaround... ;)