Forum Discussion
Web Data Source Limitations?
Anonymous,
Thank you for showing how to load into a blank query. This part worked. It loaded (588K Rows), I converted it to a table, expanded the 14 columns and all was well... until I hit refresh and got an error.
Refreshed in Query Editor:
DataSource.Error: Web.Contents failed to get contents from 'URL' (500):
Details:
DataSourceKind=Web
DataSourcePath=URL
URL=URL
I backed out the column expansion and the conversion to a table and it refreshed properly again. I then converted back to a table, expanded columns, closed query editor, and hit refresh, getting the error below again:
DataSource.Error: Web.Contents failed to get contents from 'URL' (502): Bad Gateway
What do you think? I still can't believe my colleagues in the US are not having this issue...
bcharlto,
The above error could occur when you return too much data from the data source. I would recommend you import the reuqired rows and columns in Power BI Desktop.
There is also a similar blog for your reference.
http://blogs.catapultsystems.com/cfuller/archive/2017/09/07/how-to-configure-power-bi-to-regularly-update-data-from-an-upgraded-log-analytics-workspace/
Regards,
Lydia