Forum Discussion

APQueiroz's avatar
APQueiroz
Frequent Visitor
3 years ago
Solved

Function give me DataflowContainsDynamicDatasource on DataFlow, why?

Hello guys. This is my first post in the community. Forgive me if I made any mistakes in this post. I was exploring different ways to connect to a Postgres DB. That when I create the following funct...
Dataflow
Tips and Tricks
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , APQueiroz 

    According to your description,you use a function to connect to the data source and return an error code "ErrorMessageOne or more entities references a dynamic data source.".

    Unlike Power BI Desktop it appears that PBI Service doesn't yet support a refresh of datasets which are invoked using customer functions.And this idea has been post on Power BI idea.For this ,you can refer to :
    Microsoft Idea

    If you want to create a var , you can try to use the parameter if it can meet your need.For this , you can refer to :
    Parameters - Power Query | Microsoft Learn

     

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

     

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , APQueiroz 

According to your description,you use a function to connect to the data source and return an error code "ErrorMessageOne or more entities references a dynamic data source.".

Unlike Power BI Desktop it appears that PBI Service doesn't yet support a refresh of datasets which are invoked using customer functions.And this idea has been post on Power BI idea.For this ,you can refer to :
Microsoft Idea

If you want to create a var , you can try to use the parameter if it can meet your need.For this , you can refer to :
Parameters - Power Query | Microsoft Learn

 

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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