API structure in Power BI not changing

[Anonymous]

I'm using an internal API to populate the data in my report. I'm having issues refreshing the data. If I add or delete a column to my report it is reflected in the API but not in Power BI. I did some research and found a post that suggested changing the number of columns in the advanced editor. Unfortunately I cannot do that (because of the way the developers on our team structured the API). Below is the online example I found, and then NSS is the way that my advanced editor is loading the API data.

I'm looking for ideas/suggestions on how to load or manipulate the queries so that the data in Power BI will always accurately reflect the API (specifically when adding or deleting columns). Thanks!

[v-shex-msft]

Hi @Anonymous ,

AFAIK, power query table will cache table structure in query steps. They can't dynamic changed based on previous steps, so you need to manually fix them if any changes applied on datasource side.

In my opinion, you can consider to send columns list on api side, then you can use this list in table format step.

BTW, can you confirm web connector received csv file? If this a case, you can package web.contents function with csv.document function codes.

Regards,

Xiaoxin Sheng