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. 


15 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
  10. "Looking to kickstart your career in SAP EWM? Bangalore offers a plethora of options for SAP EWM training.
    Here’s what to consider:
    SAP EWM Training in Bangalore at SAP Masters
    1.Quality Training:
    Opt for best institutes with a solid reputation and accreditation from SAP Masters Training institute.
    Look for expert faculty who can provide comprehensive insights.
    2.Curriculum:Ensure the curriculum covers core EWM concepts and offers hands-on projects for practical learning.
    3.Infrastructure: Check for modern facilities and labs equipped with the latest software to support your training needs.
    4.Placement Support: Choose institutes that offer robust placement assistance, including resume building and interview preparation.
    Consider institutes like SAP Masters Institute of Technology, sap masters Academy, and sapmasters training institute bangalore,
    known for their quality training and successful placements. Choose wisely, and jumpstart your SAP EWM journey in Bangalore!



    Visit SAP Masters - Best SAP Training in Bangalore"
    Visit SAP Masters - SAP EWM Training in Bangalore"

    ReplyDelete