Forum Discussion
Changing parameter in Service leads to missing column error for unused column
Use the v2 connector and specify a view that has fewer columns. Generally have fewer columns. Use a more robust data store like SQL server.
Hi lbendlin
I am completely sure. This report is run on many different SharePoint sites, and the columns that fail are different depending on the site that it was loaded on before it was published.
My suspission is that Power BI Service saves some metadata about which columns are in the report, (even if they are not used) and that this is the reason why changing which SharePoint site is used fails (in the Service only). Though I do not know for sure if this is the reason.
Ah, i missed the SharePoint part. Your lists likely are too wide (too many columns) and Power BI is randomly dropping columns.
Oh interesting, the tables can indeed become really wide as the power query is quite flexible with what is accepted. I haven't noticed dropped columns in the desktop, but are you suggesting that unused columns might be dropped from the datasets when uploaded to the service?