Refresh Failure ; Unable to connect to the data source undefined. My sql

[Anonymous]

gateway connection is fine... everything was fine my side bt i got below issue... please sort me out team... i tried lot many ways..

[Anonymous]

Hi @Anonymous ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Stephen Tao

[Anonymous]

Hi Team

This is my side of problem, because some network issue and am used that stored procedure so day to day before shedule refresh once call that stored procedure. this error is not coming on that still now  

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[Anonymous]

No, I didn't get any solution. then so more issues are created in the schedule refresh. Each and every time I can refresh on the data but I am getting new errors. so what can i do?..please sort me out team...

I tried lot many times but i getting like this type of error .

[Anonymous]

Hi @Anonymous ,

It seems that the crendential of your data source and your gateway both got problems.

First, check your gateway if it is installed successfully and you need to keep the gateway version the latest.

There're some considerations about gateway: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install#related-considerations

Second, when you make sure your gateway works, you may check the different privacy level settings in Power BI Desktop and Power BI Service. Make sure you have the same privacy level security:

In Power BI Desktop:

Options and Settings --> Data Source Settings

For every Datasource: -->  Edit Permissions

Set Privacy Level: e.g. „Organizational“

Power BI Service:

Datasets --> (Choose you Datasets which does not update properly) --> settings --> Gateway Connection --> Actions --> (expand you cluster to show all Data Sources) --> (Choose relevant Datasource) --> Advanced Settings --> Privacy setting --> set same level (e.g. „Organizational) as in Power BI Desktop

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous ,

There is a similar posts which you can refer to:

https://community.powerbi.com/t5/Desktop/Problems-refreshing-data-from-MySQL-database-with-May-2017/td-p/170324

Or please check if the credentials of the data source are expired

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous - Can you check in your dataset if there is any date column?

The value of date is 0000-00-00 by any chance?

Most likely this looks to me like a data related issue (Run time exception)

Hope this helps.

Cheers,

-Namish B