Forum Discussion
Solved
Changing parameter in Service leads to missing column error for unused column
I have created a report which get data from different SharePoint sites. Which SharePoint site is used, is defined by a parameter in the report. When I try changing that parameter in Power BI Se...
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.
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?