Workaround dynamic Datasource Refresh issues using OData Feed

[Anonymous]

Hi there,

I created a Report that uses an OData-Feed. The Connector is available in powerBI and everything works fine.

Due to the fact that the OData Feed is not the fastest and cannot handle too much data I first changed the OData Connection into a function which I then use in another Query where I created a table of different Input values and used the "Invoke Custom Function" to hand the data over into my OData Feed function.

In Power Query I get the Error: "This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources."

My Question: Is this only a problem because the OData Feed is inside of a function or is an OData Feed always not able to be updated in PowerBI service?

Is there a workaround?

[Anonymous]

Hi @Anonymous ,

To my knowledge OData Feed datasource .pbix file could refresh in Power BI.

For your needs, please try to create a custom data connector,To create a custom data connector, you may refer the articles below.

Create a Power Query custom data connector in 10 minutes

Building a custom connector for Power BI that supports OAuth2 to visualize my wellness data

Custom Data Connector: How to Deploy and Test

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous 

first of all thanks for your suggestions.

Your workaround seems complicated, but I´m sure it can work. The thing is in my company envorinment custom solutions like that normally are a lot of work - not programming, but getting it run with all the security environment we have. I think to get this custom connector done it will take too much time.

Is there an easier solution maybe?