Forum Discussion

pawankarki23's avatar
pawankarki23
Frequent Visitor
1 year ago
Solved

Dynamic Data source error in PowerBI Service

Hi Everyone, I am trying to fetch data from ADO Board using Power query using Odata.Feed. I have multiple ADO Boards acrros the organization and would like to make the query as dynamic as possible fo...
Need Help
  • jennratten's avatar
    jennratten
    1 year ago

    Hi pawankarki23 - I have confirmed that if I use the same code I posted above in a dataflow gen1 I also get the dynamic data source error.  This was successful for me as a dataflow gen2 CICD.  

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi pawankarki23,

Thank you for reaching out to the Microsoft Fabric Forum Community.

 

The "Dynamic Data Source" error you're encountering is a known limitation in the Power BI Service, as documented by Microsoft. To overcome this, you should use a static base URL in your query. 

Please refer the below Document: 

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn.

 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

 

Thank you.