Wednesday, April 18, 2018

Export Power BI dataset to Excel PowerPivot

The Power applications are hitting the Dynamics 365 space by storm. Lots of interest there. 

Whether its a customer wanting to set up some Power BI dashboards or trying to figure out how to get data out of my own company's Power BI 'dataset' there can be some hurdles. 

When I jumped into PowerBI, I was overwhelmed. Its easy to create reports when you know the application as well as the data that you need to pull from. Problem is, if you don't know the data, you can't get very far. 

I can figure out how to create BI if I know the table structure and have an idea of what the tables are and how they link together (Figure 1). But if I don't, what now? I can click on these fields one by one and see them in PowerBI UI but I don't have the freedom to copy and paste the data for further analysis. 


I export the datasets to Excel (where I'm more comfortable) and use PowerPivot type concepts through the below. I'll go one by one and see the data and how they interact with the other datasets to really learn what we have at our disposal.

Hopefully this short but sweet technique will help get you up and rolling with your Power BI data. 


13 comments:

  1. I feel satisfied to read your blog, you have been delivering a useful & unique information to our vision even you have explained the concept as deep clean without having any uncertainty, keep blogging. Power BI Online Training Bangalore

    ReplyDelete

  2. It was so nice article. I was really satisfied by seeing this article. Power BI Online Training Bangalore

    ReplyDelete
  3. I really enjoy reading your blog - I learn a lot thanks to him! Especially, that I use Aegis microsoft ax ( https://ax-dynamics.com/microsoft-dynamics-ax I don't know how my company works without it, it gives so much! It improves everything - almost every department in the company.

    ReplyDelete
  4. Thanks for sharing your experience. Such very useful info. If you want more info IRS 1099 MISC Form Online

    ReplyDelete
  5. This is the exact information I am been searching for, Thanks for sharing the required infos with the clear update and required points. To appreciate this I like to share some useful information.
    Power Bi Training in Bangalore

    ReplyDelete
  6. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    Power Bi training in bangalore
    Power Bi institutes in bangalore



    ReplyDelete
  7. Thanks for sharing your experience About Power Bi dataset to Excel PowerPivot. Such very useful info.

    ReplyDelete
  8. I appreciate the effort you put into this article. It is both informative and uplifting.
    Embedded C Training in Hyderabad

    ReplyDelete
  9. This is web site is very useful and also very like this domain our web site https.//sclinbio.com

    ReplyDelete