Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi,
Problem is mentioned in subject, "Use a data gateway" sub-title rejected to display its content but deadly in waiting state.
What could I do to move on?
Solved! Go to Solution.
@Ryan_Xiao,
I would recommend you open a support ticket on the support.powerbi.com site.
Regards,
Lydia
@Ryan_Xiao,
Restart your on-premises gateway service, make sure that you add all data sources of your dataset within the gateway, then check if the issue still occurs.
Regards,
Lydia
hi, Lydia
Thanks for your reponse!
Unformtunately, it still does not work even after gateway is restarted. Two used csv files were successfully added to gateway cluster, as below.
Any further suggestion?
@Ryan_Xiao,
Could you please post the screenshot about data sources in Power BI Desktop? Do you use same path and credentials for these csv files in Power BI Desktop and gateway?
Regards,
Lydia
Hi, Lydia
About data source, they are from two points, web and mySQL. I added all related csv files and mySQL tables. These csv files are from different folders of the same web server, two samples pasted below.
Screenshot about data sources in Power BI Desktop
@Ryan_Xiao,
Please mask sensitive information such as email address when you upload images. In gateway, you also use IP address when adding MySQL data source, right?
Does this issue occur for this specific dataset or all datasets?
Regards,
Lydia
hi, Lydia
Thanks for your reminder on sensitive information!
Yes, IP Address is used for mySQL data source.
@Ryan_Xiao,
Does this issue occur for all the datasets in your Power BI Service?
Regards,
Lydia
Hi, Lydia
Yes. So far, I generated two PBI services and both services' dashboard update is blocked by the issue.
By the way, My gateway is running on one Windows VM.
@Ryan_Xiao,
I would recommend you open a support ticket on the support.powerbi.com site.
Regards,
Lydia