Forum Discussion

MAVIE's avatar
MAVIE
Helper 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
Super User
3 years ago

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

MAVIE's avatar
MAVIE
Helper I
3 years ago

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

  • lbendlin's avatar
    lbendlin
    Super 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.