Hi all,
We are working on a POC where we want to create a reusable Power Query that pulls data from a Azure SQL database. We want that data to be inserted in a PowerPivot model which should be refreshed automatically from a Power BI site.
As per the following documentation we understand it should be possible:
https://support.office.com/en-gb/article/Supported-Data-Sources-and-Data-Types-cb69a30a-2225-451f-a9d0-59d24419782e?ui=en-US&rs=en-GB&ad=GB
However we are struggling to do so.
We have tried to create a data source on the Power BI admin center using the connection string coming from the Power Query however we got the following error:
Unsupported data source types detected
The Power Query connection string contains one or more unsupported data source types: {DataSourceKind}. Please refer to the data source support matrix to review the data source types supported from a Power Query connection string.
On the one hand we understand that Power Query is a valid data source for Power BI sites and Azure SQL is also a valid data source for a Power Query query. What are we missing?
Could you please confirm that it is possible to refresh a Power Pivot model that reads the data from a Power Query which in turns pulls from an Azure SQL database?
Could anybody provide some gidelines about how to do it?
Thanks for your help