DirectQuery in PowerBI - converting old Excel PowerPivot Models

Used for anything related to the new Power BI Desktop and Service tools
Jørgen Wulff
Posts: 3
Joined: Tue May 16, 2017 10:26 pm

DirectQuery in PowerBI - converting old Excel PowerPivot Models

Postby Jørgen Wulff » Tue May 23, 2017 7:00 pm

I have a number of Power Pivot Models, that works fine in Excel, but they are +50MB, so I want to convert them to Power BI (to create a single source to update), but I also want to create the models as direct queries.

Does anyone have experience in doing this, and what are the disadvantages?

I tried to import from Excel, but it seems like I can not change to direct query, and If I start building my direct query, I am missing my possibilities to create functions in the Edit Query part of Power BI.

So any help or suggestions for an easy workaround are welcome.

regards

Jørgen

MattAllington
Posts: 873
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: DirectQuery in PowerBI - converting old Excel PowerPivot Models

Postby MattAllington » Mon Jun 12, 2017 1:47 pm

You can't change from a traditional power pivot to direct query
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax


Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 1 guest