Forum Discussion

MAVIE's avatar
MAVIE
Icon for Helper I rankHelper I
3 years ago
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...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Ah, i missed the SharePoint part. Your lists likely are too wide (too many columns) and Power BI is randomly dropping columns.

MAVIE's avatar
MAVIE
Icon for Helper I rankHelper I
3 years ago

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? 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    I didn't say "unused" - I said "random"...

    • MAVIE's avatar
      MAVIE
      Icon for Helper I rankHelper I
      3 years ago

      Alright. Well are you aware of any solution to this issue?

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        3 years ago

        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.