Forum Discussion

B_Caron's avatar
B_Caron
Frequent Visitor
10 years ago
Solved

Manual Data Entry in Power BI Services

Hi all,,

 

I was curious to see Power BI Services options for manual data entry. The business I am working for currently is using a simple KPI system and we are upgrading to Power BI. That being said, the simple KPI system in use is based on a mix between manual data entry from different regions and automation. I was wondering if Power BI services offered any options with manual data entry or if that is only a feature of Power BI desktop.

 

Thanks,

 

BC

  • You could create an Excel sheet and manually input your date there and then create a PBI Desktop file that use this Excel sheet as a source.

  • B_Caron If you only want to use power bi service and not desktop, then you can use One Drive and do manual data entry there and connect to it live from power bi service.

     

5 Replies

  • ankitpatira's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion

    B_Caron If you only want to use power bi service and not desktop, then you can use One Drive and do manual data entry there and connect to it live from power bi service.

     

  • kcantor's avatar
    kcantor
    Icon for Community Champion rankCommunity Champion

    I beleive this is a function of the desktop only. However, you can change your source file to update it as needed in the service.

    • sdjensen's avatar
      sdjensen
      Icon for Solution Sage rankSolution Sage

      You could create an Excel sheet and manually input your date there and then create a PBI Desktop file that use this Excel sheet as a source.

  • B_Caron's avatar
    B_Caron
    Frequent Visitor

    sdjensen

    This will provide a awesome alternative for those waiting to upgrade to Drive One!

     

     

    ankitpatira

    It hadn't cross my mind to do this, amazingly simple and efficient way to stream line the data entry!

     

     

    Thanks for everyone for your great replies and I wish I could accept all of these as solutions as they serve different purposes. 

    (I guess I can accept multiple answers! Nevermind)

     

    This is my first post and am very excited to join the Power BI community.

     

    Much Appericiated,

    BC

    • OneWithQuestion's avatar
      OneWithQuestion
      Icon for Post Prodigy rankPost Prodigy

      What about power apps?

       

      Can anything there integrate so that you can use power apps to record data and show PowerBI dashboards inside the app?

       

      So use the app as a data entry wrapper around PowerBI?