Forum Discussion

LilyLe_MAN's avatar
LilyLe_MAN
Frequent Visitor
8 years ago

Is SSAS Tabular model strongly recommended to manipulate data before creating Power BI dashboards?

Dear experts,   I am looking for a solution to make use of SQL Server, SSAS Tabular Model, Power BI desktop, Power BI Report Server effectively.   The company I am working for use SAP datawarehou...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi LilyLe_MAN,

 

1. Power BI report server October version does support SQL Server imported data model. See:Power BI report data sources in Power BI Report Server.

 

2. The "Publish" button is used for publishing report to Power BI service instead of Power BI report server. To publish report from desktop to Power BI report server, we need to use File-> Save as-> Power BI report server. Here is a feature request for Provide option to 'Publish to Report Server' instead of 'Save As' on Power BI Desktop for Report Server which you can vote it. 

 

We can configure schedule refresh for SQL Server Import mode: How to configure Power BI report scheduled refresh.

 

3. You can see jtarquino's reply in this same thread: RLS In PowerBi On Prem. Also you can vote for this idea:Dynamic row-level security for Power BI Report Server.

 

Best Regards,
Qiuyun Yu