Forum Discussion

DrBiker's avatar
DrBiker
Advocate II
10 years ago

Direct query with mySQL using Power BI Embeded

I have a mySQL database that I can connct to, and manually refresh, using Power BI Desktop, however I need to deploy the desktop solution to an embedded solution.     Is it posible to use Direct Qu...
Need Help
DrBiker's avatar
DrBiker
Advocate II
10 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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.