Forum Discussion
API structure in Power BI not changing
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...
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