Forum Discussion

RC-CBEx's avatar
RC-CBEx
New Member
4 years ago
Solved

Using Power BI to Produce Reports for Many Users

I am trying to determine a solution for my reporting needs at work. It was suggested that I use Power BI (which I do not have familiarity with). I have watched some basic training videos. But I am tr...
Need Help
  • mohammedadnant's avatar
    mohammedadnant
    4 years ago

    Hi RC-CBEx 

     

    Analyze in Excel is only possible if you publish your report to Power BI service (Pro/Premium),

    users need a Power BI pro license unless you have a Premium license.

    when you share the report with the user, they can open an excel file and connect the Power BI dataset to analyze in excel or they can download the excel file in more options of Power BI Dataset in Power BI Service

     

    Power BI Desktop is only for development and   

     

     

mohammedadnant's avatar
mohammedadnant
Impactful Individual
4 years ago

Hi RC-CBEx 

 

1st you can do all your requirement in Power BI, 

you can import all you excel file in Power BI  and 

Mostly all kind of transformation can be possible in Power Query,

please refer this playlist: https://www.youtube.com/playlist?list=PLBGVH95YWOV0bdbX_7XZ5i_3qSM01Un-F

 

once you develop your report --> you can share it with your users to access directly in Power BI if not there is an option of Analyze in Excel, you can share the Power BI dataset --> multiple users can connect the Power BI dataset in excel 

refer this video: https://youtu.be/p80bN4ACGYM

 

In Short: Power BI is really powerful tool for your BI analytics needs,