how to make power BI from mysql/api with filter periode date

[richyrich14]

dear admin,

please solve my problem in power BI. i want to import data from mysql/api to make dashboard power BI. this data is a real time.

such as this data from period 1 january 2017 until 27 july 2017, i want to make dashboard in period 5 april 2017 until 12 july 2017.

how to make this filter from this case, because i will to make power BI by request for periode date.

thanks

[richyrich14]

dear admin,

please solve my problem in power BI. i want to import data from mysql/api to make dashboard power BI. this data is a real time.

such as this data from period 1 january 2017 until 27 july 2017, i want to make dashboard in period 5 april 2017 until 12 july 2017.

how to make this filter from this case, because i will to make power BI by request for periode date.

thanks

[v-caliao-msft · Accepted solution]

@richyrich14,

Since Parameter not works in Power BI services, I am afraid you need to use slicer to change the date. Then on Power BI services, you need add data source in your gateway, and you can refresh your data on a schedule. Please refer to the links below to see the details.

http://biinsight.com/mysql-and-power-bi-how-does-it-work/

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-slicers/

Regards,

Charlie Liao