Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

On Prem Tabular... what's allowed?

Say I have an on-prem tabular server.  It will be used to serve excel reports (hosted on sharepoint) and dashboards in power bi.   All from a single model, that's hot!

 

Question:  what exactly will my experience be in Power BI?

By default, I am sorta assuming I will have a live connection (do I still call that DirectQuery?) -- and I will not be adding any new measures (etc) in Power BI.  It's just... a report builder.

 

But I get the feeling I can also... do some freaky import into Power BI... still re-use my existing measures (from tabular) and add new measures in Power BI?   Is that... good or bad? 🙂

 

(Would go try it, but the Tabular server isn't up yet... suppose I could try out the new Azure SSAS!)

Thanks for infos!

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

Hi @Anonymous,

Based on your description, you refer to that connecting to on-premises SSAS tabular model from Power BI Desktop, right?

If that is the case, choosing which connection type(Live connection or Import) depends on your requirements, you can make a decision after checking the following points about the two connection type.

    a. “Live Connection” is more appropriate when you work with much large model solution and you need to directly access an tabular model. It offers the most secure and robust method for building and maintaining a Power BI solution. However, if you created a live connection , all of the query and modeling features in Power BI Desktop are disabled, and you can’t create new measures, also you are not able to connect to another type of data source in the same Power BI Desktop file. Live Connection requires Enterprise level SQL (up until SQL 2016).

    b. With import connection, you are able to use Power BI Desktop’s advanced Query Editor to further shape data, and you can use Power BI Desktop’s modeling features to further model the data. Of course, you are OK to create new measures. However, it could take a while to load or refresh larger data sets, or data sets that have been heavily manipulated. Also in this scenario, when you publish Power BI Desktop file(PBIX file) to Power BI Service, it has a 1GB limit to the PBIX file.

Reference:
Analysis Services Tabular data in Power BI Desktop

Power BI Connection Types

Thanks,
Lydia Zhang

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

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Employee
Employee

Hi @Anonymous,

Based on your description, you refer to that connecting to on-premises SSAS tabular model from Power BI Desktop, right?

If that is the case, choosing which connection type(Live connection or Import) depends on your requirements, you can make a decision after checking the following points about the two connection type.

    a. “Live Connection” is more appropriate when you work with much large model solution and you need to directly access an tabular model. It offers the most secure and robust method for building and maintaining a Power BI solution. However, if you created a live connection , all of the query and modeling features in Power BI Desktop are disabled, and you can’t create new measures, also you are not able to connect to another type of data source in the same Power BI Desktop file. Live Connection requires Enterprise level SQL (up until SQL 2016).

    b. With import connection, you are able to use Power BI Desktop’s advanced Query Editor to further shape data, and you can use Power BI Desktop’s modeling features to further model the data. Of course, you are OK to create new measures. However, it could take a while to load or refresh larger data sets, or data sets that have been heavily manipulated. Also in this scenario, when you publish Power BI Desktop file(PBIX file) to Power BI Service, it has a 1GB limit to the PBIX file.

Reference:
Analysis Services Tabular data in Power BI Desktop

Power BI Connection Types

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Perfect!  Thanks @v-yuezhe-msft.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors