Solved: Refresh of Dataset failing when using PowerBi Onli...

swstrath · ‎10-04-2022

I have created a dashboard that monitors certain enterprise app sign in details, its built upon json files stored in a sharepoint library. This all seems to work fine using desktop PowerBi, but when I publish it to web version the dataset does not refersh.

I receieve the following error, "We found extra characters at the end of the JSON input." The JSON files are outputs from PowerAutomate and I have ran them through a verifier with no issues.

Wondering if anyone can shed some light on why this works on desktop but not web?

swstrath · ‎10-21-2022

I managed to fix the issue, the web power bi was using the wrong set of Sharepoint credentials for the data refresh. Once I updated the credetials the refresh worked as expected.

Update: This only appears to fix the issue, the actual issue was that I needed a text filter that filtered out other files in the Sharepoint Root. It was picking up some excel files in another document library which was messing it up.

View solution in original post

swstrath · ‎10-21-2022

I managed to fix the issue, the web power bi was using the wrong set of Sharepoint credentials for the data refresh. Once I updated the credetials the refresh worked as expected.

Update: This only appears to fix the issue, the actual issue was that I needed a text filter that filtered out other files in the Sharepoint Root. It was picking up some excel files in another document library which was messing it up.