Forum Discussion
Advocate IIDirect query with mySQL using Power BI Embeded
Advocate IIThanks for the response, however we are not using Power BI service as this is insecure, we are using Power BI embedded which does not seem to have that option.
DrBiker The only supported data sources for Power BI Embedded (in preview) are cloud sources. Azure SQL Database, Azure SQL Warehouse.
here is the FAQ
relevant section:
What data sources are currently supported with Power BI Embedded?
During the public preview of the service, we are going to support access to cloud data sources that use basic credentials via Direct Query. This means that sources such as Azure SQL DB, HDInsight Spark and Azure SQL DW are supported right now. We will add support for other data sources and access types in the coming months. We’ll announce new supported data sources on the Power BI developer site at http://dev.powerbi.com.
- DrBiker
Thanks,
So is there a way to automate the refresh of data in desktop to produce a new pbix file? I can automate the provisioning of the new pbix easily enough.
Thank in advance.
DrBiker Due to the current limited data sources, the only option for connection that they provide to you at the moment is "Direct Query". This method of connection to a data sources does not require refreshing as it is always up to date.
Automating refreshes for a data set is handled in the Power BI Service. I am not aware of any method to update a PBIX file locally.
The on-premise solution rolls into SSRS 2016, and that refresh is handled via SSRS I believe.