Forum Discussion

daveedd's avatar
daveedd
Icon for Helper II rankHelper II
4 years ago
Solved

Pull selected columns from Web source without removing after

Hi all,   I'm connecting to a ServiceNow table via a web source.  That table has 155 columns of which I want around 30.  I know I can pull all 155 and remove the ones I don't want, but is there a w...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi daveedd 

    That does not matter, because only the first 1000 rows are loaded in power query, you can see the prompt in the lower left corner of the software. Hence, only the remaining columns will be loaded into the data model if you remove some columns in Power Query Editor.

    -

    However, when your Power BI Desktop file contains many queries, retrieving and storing preview data can extend the time it takes to complete a refresh. You'll achieve a faster refresh by setting the Power BI Desktop file to update the preview cache in the background.

    In Power BI Desktop, you enable it by selecting File > Options and settings > Options, and then selecting the Data Load page. You can then turn on the Allow data preview to download in the background option.

    Note this option can only be set for the current file.

    FYI: Disable Power Query background refresh - Power BI | Microsoft Docs

     

     

    Best Regards,

    Community Support Team _Tang

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

daveedd , select 30, and remove others in power query.

daveedd's avatar
daveedd
Icon for Helper II rankHelper II
4 years ago

amitchandak  Thanks for the response - I was wondering if there's a way to limit the data coming in rather than removing after the initial pull.  Pulling 125 unnessisary fields and then removing them feels inefficient.

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi daveedd 

    That does not matter, because only the first 1000 rows are loaded in power query, you can see the prompt in the lower left corner of the software. Hence, only the remaining columns will be loaded into the data model if you remove some columns in Power Query Editor.

    -

    However, when your Power BI Desktop file contains many queries, retrieving and storing preview data can extend the time it takes to complete a refresh. You'll achieve a faster refresh by setting the Power BI Desktop file to update the preview cache in the background.

    In Power BI Desktop, you enable it by selecting File > Options and settings > Options, and then selecting the Data Load page. You can then turn on the Allow data preview to download in the background option.

    Note this option can only be set for the current file.

    FYI: Disable Power Query background refresh - Power BI | Microsoft Docs

     

     

    Best Regards,

    Community Support Team _Tang

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