Forum Discussion
Automatic Refresh not Bringing Up New Columns Added to Sharepoint
Hello, We have set a Power BI Report that pulls Data from Sharepoint Online and refresh it on a daily basis. New data are being updated correctly and everything is working fine except for new col...
GilbertQ
Super User
Super UserHi there
That does appear to be as if it is not working as expected.
What if you had to try the previous API version?
That does appear to be as if it is not working as expected.
What if you had to try the previous API version?
Hi GilbertQ,
I tried the API version 14, but Power BI gave me an error along the lines of “The key did not match any line in the table. Details: Key=Record Table=Table” (translated from portuguese). I figured out that we probably cannot use version 14 because our site language is portuguese. It seems like version 16 is not available.
PS: I tried creating a new list, in a different site, but the same behavior was seen. Newly created columns did not appear in the field list after an on demand refresh in Power BI Online, but did after a refresh through Power BI Desktop.
Appreciate your help.