Scalable Power BI data model on delta lake ADLS Gen2

0 votes

Our current architecture for reporting and dashboarding is similar to the following:

[Sql Azure] <-> [Azure Analysis Services (AAS)] <-> [Power BI]

We have almost 30 Power BI Pro Licenses (no Premium Tier)

As we migrate our on-premise data feeds to ADLS Gen2 with Data Factory and Databricks (in the long run, we will dismiss SQL Azure DBs), we investigate how to connect Power BI to the delta tables.

Several approaches suggest using SQL Databricks endpoints for this purpose:

https://www.youtube.com/watch?v=lkI4QZ6FKbI&t=604s

IMHO this is nice as long as you have a few reports. What if you have, say, 20-30? Is there a middle layer between ADLS Gen2 delta tables and Power BI for a scalable and efficient tabular model? How to define measures, calculated tables, manage relationships efficiently without the hassle of doing this from scratch in every single .pbix?

[ADLS Gen2] <-> [?] <-> [Power BI]

As far as I can tell, no AAS Direct Query is allowed in this scenario: https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-datasource

Is there a workaround to avoid the use of Azure Synapse Analytics? We are not using it, and I am afraid we will not include it in the roadmap.

Thanks in advance for your invaluable piece of advice

Feb 17, 2022 in Power BI by surbhi
• 3,820 points
1,892 views

1 answer to this question.

0 votes

You may use the new Delta Sharing Connector for Power BI to create Power BI Import Models from Delta tables without having to go through Databricks SQL or Spark. Alternatively, you can use a Spark job to export the model data to a Data Lake format that Power BI/AAS can read.

If you require DirectQuery models, you should use Synapse SQL Pool or Synapse Serverless, as these expose the data as SQL Server endpoints, which Power BI and AAS support.

You can define measures, calculated tables, manage relationships in an AAS Tabular Model or a Power BI Shared Data Set.

Unlock the Power of Data Visualization with Our Comprehensive Power BI Course!

answered Feb 17, 2022 by CoolCoder
• 4,420 points

Related Questions In Power BI

0 votes
1 answer

How to troubleshoot a refresh on data set in power bi service

Hello, @vnk, You may see an error when ...READ MORE

answered Sep 14, 2020 in Power BI by Gitika
• 65,890 points
959 views
0 votes
1 answer
+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,540 points
13,890 views
0 votes
1 answer

Group by columns on Power BI

On power BI desktop, do the following Add ...READ MORE

answered Sep 25, 2018 in Power BI by Kalgi
• 52,360 points
926 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,360 points
959 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,360 points
844 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,360 points
1,183 views
+1 vote
1 answer
0 votes
1 answer

Power BI On-Premises Data Gateway through a VM for customers?

There isn't any other choice, To connect ...READ MORE

answered Feb 21, 2022 in Power BI by CoolCoder
• 4,420 points
3,141 views
0 votes
1 answer

Categorised data in Power BI

Use a helper table to store these ...READ MORE

answered Feb 8, 2022 in Power BI by CoolCoder
• 4,420 points
626 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP