PowerBi Embedded restrictions in scheduled refresh data?

[babiskon]

Hello to all, 

In my company we want to create a web application and use Powerbi embed to display the dashboard. 

Currently the data are in a mysql database and the metrics stored there are in a JSON format. 

To my understanding mysql does not support direct query and direct query is needed for updating the data (live or scheduled refresh) with the Powerbi embeded. is there any other way to refresh the data from the mysql?

We have created a sql database and transfered a table of the data there in order to have the direct query. But when i tried to expand the json powerbi desktop says that this step is not supported with the direct query and I should use import. But if use import then I return to the same situation that I have with mysql, correct? 

So there is the question, how do set up a scheduled data refresh in mysql or sql when the data are in json format?

thanks a lot, sorry for the long post. 

[v-yuezhe-msft]

Hi @babiskon,

Yes, Power BI embedded doesn’t support scheduled refresh for import mode dataset. And since you hit the unsupported features in DirectQuery mode, I am afraid  that you have to refresh the PBIX file manually and re-import each time you have updated data at the current time.

Thanks,
Lydia Zhang