cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
babiskon New Member
New Member

PowerBi Embedded restrictions in scheduled refresh data?

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. 

 

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: PowerBi Embedded restrictions in scheduled refresh data?

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.