Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Datasource rendering

Hi All,

 

I am working on a report where user wants to load dataset everytime.SO please let me know how to give that feature, where the user loads data everytime when he wants to see the report. WE want to give load dataset from datasource feature and hen the user can see the report created with default visualization.

Need Help

8 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    6 years ago

    If the user has access to the data, you can just give them the pbix button and show them where the Refresh button is on the ribbon.

     

    If not, you could add a simple PowerApp with a refresh button to your report that has a connected flow to refresh the dataset.  However, based on your plan, you have a limited number of refreshes per day.

     

    Regards,

    Pat

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      mahoneypat 

      Thnaks it solved my other problem.

       

      But the problem remains unsolved...

       

      I want everytime user to load new data from new datasource. Like the one there is a feature in PowerBI Get DATA which asks which datasource to use.

      • mahoneypat's avatar
        mahoneypat
        Microsoft Employee
        6 years ago

        One way to get that functionality is to create a Parameter in the query editor to hold the datasource path/file/etc., and the replace the hardcoded path/file/etc. in your query with the name of that parameter.  If you then save your pbix as a pbit file (template file) and send that to your user.  When they open it, they will get prompted to fill in that parameter before refresh.

         

        Please see an article I wrote on this topic - https://hoosierbi.com/2019/04/07/template-files-are-an-under-sung-feature/

         

        If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

        Regards,

        Pat

         

         

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thnaks it solved my other problem.

       

      But the problem remains unsolved...

       

      I want everytime user to load new data from new datasource. Like the one there is a feature in PowerBI Get DATA which asks which datasource to use.

      amitchandak 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I want everytime user to load new data from new datasource. Like the one there is afeature in PowerBI Get DATA which asks which datasource to use.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thnaks it solved my other problem.

       

      But the problem remains unsolved...

       

      I want everytime user to load new data from new datasource. Like the one there is a feature in PowerBI Get DATA which asks which datasource to use.