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 in Power BI by surbhi
• 3,810 points
197 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.
answered Feb 17 by CoolCoder
• 4,360 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,850 points
247 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,570 points
11,641 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,350 points
295 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,350 points
336 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,350 points
278 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,350 points
454 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 in Power BI by CoolCoder
• 4,360 points
301 views
0 votes
1 answer

Categorised data in Power BI

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

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