Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dataset will not refresh

I have a simple Dataset that contains 2 tables. one table has a list of all my databases and the other is a dynamic function (see code below). I Invoke a custom function on database single column tab...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    The documentation describes:

    If that warning is present in the Data Source Settings dialog that appears, then a dynamic data source that can't be refreshed in the Power BI service is present.

     

     

    Best Regards
    Community Support Team _ Polly

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

Do you seem to use import to connect to sql.database?

Please have a check. To determine whether your dynamic data source can be refreshed, open the Data Source Settings dialog in Power Query Editor, and then select Data Sources In Current File. In the window that appears, look for the following warning message, as shown in the following image:

Data refresh in Power BI - Power BI | Microsoft Learn

 

If the warning does not exist, please provide the screenshot.

 

Could you please provide you pbix file without privacy inforamtion for me to test?

 

Best Regards
Community Support Team _ Polly

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Anonymous yes as you suggest I get that error. I am hoping there is a work around just like there is a work around for web.contents by using relative path? I will work to post the file. Thanks,

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

    The documentation describes:

    If that warning is present in the Data Source Settings dialog that appears, then a dynamic data source that can't be refreshed in the Power BI service is present.

     

     

    Best Regards
    Community Support Team _ Polly

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