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. 


17 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. Enjoyed reading the article above, really explains everything in detail, the article is very interesting and effective. Thank you and good luck for the upcoming articles Learn power bi online training
    power bi online training Hyderabad
    power bi online course
    power bi training
    power bi certification
    power bi online training India

    ReplyDelete
  6. Thank you for sharing the article. The data that you provided in the blog is informative and effective.

    Tableau Training in Hyderabad

    ReplyDelete
  7. 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
  8. 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

  9. I am really happy to say it’s an interesting post to read . I learn new information from your article , you are doing a great job . Keep it up

    Devops Training in Hyderabad

    Hadoop Training in Hyderabad

    Python Training in Hyderabad

    Tableau Training in Hyderabad

    Selenium Training in Hyderabad

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

    ReplyDelete
  11. Nice thanks for sharing informative post like this keep posting if like more details visit my website linkhttps://digitalbrolly.com/digital-marketing-course-in-hyderabad/

    ReplyDelete