Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hi @Anonymous ,
What is your data source?
Regards,
Yuliana Gu
As a datasource I use Azure-hosted SQL DataMart.
Hi @Anonymous ,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.