Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Dataset Refresh

  • 1.  Dataset Refresh

    Posted 15 days ago

    Hi, i have created some dataflows which i then pull into a dataset file which i want to be a central dataset file which can service all reports. All the transformations are performed in the dataflows there is no transformations taking place in the dataset and there are no visuals, when i trigger an on demand refresh the dataset it refreshes in under 30 seconds, which is great.

    However, I have now started to add some basic measures into the central dataset (real basic sum of amoun columns) so that when users create their own reports and use this dataset as their source there is already some basic measures in place, however the on demand refresh time of the dataset now jumps to 3 mins, why is that? I was under the impression measures were only calculated at the point they are loaded into visuals, therefore as there are no visuals in my dataset i was not expecting this performance drop.

    Have i done something wrong? Any ideas, suggestions would be much appreciated, thanks



    ------------------------------
    Ben Stirton
    ------------------------------


  • 2.  RE: Dataset Refresh

    Top Contributor
    Posted 15 days ago
    Hi Ben:
    They say you should schedule your dataflow refresh at least 30 minutes before your dataset refresh.

    I hope this helps.

    Bill

    ------------------------------
    William Skelley
    01106
    Longmeadow MA
    8602807221
    ------------------------------



  • 3.  RE: Dataset Refresh

    Top Contributor
    Posted 15 days ago
    Hi Ben,

    Microsoft have not so far made the refresh for data stored in files in SharePoint obvious, and the "hack" for this is to use the get data from Web source.

    You can check out this video for refreshing data from Excel when it is stored in SharePoint/Teams, and you can use the same "hack" for an Access file as you can see from the image below.



    You can see the database stored in SharePoint in the image below.



    ------------------------------
    Ben Howard, UK.

    Please mark any answer as recommended if it helps you.
    ------------------------------



  • 4.  RE: Dataset Refresh

    Posted 12 days ago
    Thanks for the replies folks, i have managed to fix the issue which was related to my dataflow.

    ------------------------------
    Ben Stirton
    ------------------------------