cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
GN314 Frequent Visitor
Frequent Visitor

Create dataset with direct query for mln rows

Hello PowerBI experts.

 

Here is the case I need your help with. I have a data mart with mln records I would like to create a dataset with direct query to  it and published in power bi premium. To do that I set up the connection using powerbi desktop and publish to server. As it is mlns of records it takes an hour to load data before publishing. Is there any other way to do that? Say, create connection in desktop without pooling whole data or create connection from premium server directly bypassing desktop?

 

3 REPLIES 3
v-yulgu-msft Super Contributor
Super Contributor

Re: Create dataset with direct query for mln rows

Hi @GN314 ,

 

What is your data source?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GN314 Frequent Visitor
Frequent Visitor

Re: Create dataset with direct query for mln rows

As a datasource I use Azure-hosted SQL DataMart.

v-yulgu-msft Super Contributor
Super Contributor

Re: Create dataset with direct query for mln rows

Hi @GN314 ,

 

Do you mean Azure SQL Database? If so, it is possible to create live connection to Azure SQL DB, for details: Azure SQL Database with DirectQuery

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 103 members 1,741 guests