Forum Discussion

DNKL's avatar
DNKL
Icon for Helper I rankHelper I
5 years ago
Solved

Using list.contains function blocks data refresh in service

Hi all,    In a Power BI report, I have used the following function to limit the amount of data that is being imported into the model:    = Table.SelectRows(#"Added Items", each List.Contains(Par...
Need Help
  • DNKL's avatar
    DNKL
    5 years ago

    Hi Lionel, 

     

    Thank you for checking in! 

     

    After a few weeks of using a work-around, I found out by chance that the problem was resolved by changing the location settings of the dashboard. No idea why this was the issue - it has been quite frustrating. 

     

    Best, 

    DNKL

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi DNKL ,

 

Has your problem been solved?

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • DNKL's avatar
    DNKL
    Icon for Helper I rankHelper I
    5 years ago

    Hi Lionel, 

     

    Thank you for checking in! 

     

    After a few weeks of using a work-around, I found out by chance that the problem was resolved by changing the location settings of the dashboard. No idea why this was the issue - it has been quite frustrating. 

     

    Best, 

    DNKL