cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BILive Frequent Visitor
Frequent Visitor

Override PBI SSAS-based dataset with Service-based model

have a PBI Analysis-service-based model on powerbi.com, and I'm trying to override it by uploading new Service-based model. The dataset is not changing, no netter what I'm doing, and remains SSAS-based, and the report displayed with error (Couldn't load the schema for the database model).
It is important for me to stay with the same ReportID since its embedded in another app, so I cannot just delete it and upload new model. What should I do?......

3 REPLIES 3
Community Support Team
Community Support Team

Re: Override PBI SSAS-based dataset with Service-based model

Hi @BILive,



have a PBI Analysis-service-based model on powerbi.com, and I'm trying to override it by uploading new Service-based model. The dataset is not changing, no netter what I'm doing, and remains SSAS-based, and the report displayed with error (Couldn't load the schema for the database model)

 

From your imformation, if I understand your scenario correctly that your data source is SQL Server Analysis Service and you published the report based on that data source to Power BI Service before, and now you want to republish this report to Power BI Service but it show errors?

 

If it is, by my tests, I cannot reproduce your issue. 

 

If I misunderstand, please share your detail steps so that I can have a test with your steps.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BILive Frequent Visitor
Frequent Visitor

Re: Override PBI SSAS-based dataset with Service-based model

Dear @v-piga-msft,

 

Thanks for your replay.

 

Here is my case:

 

I had a pbix with SQL as data source.

I uploaded it to the service, and all work fine. (the data stored in the service in that case)

Every time that I re-publish the PBIX, it overrides the old file, and it workes well.

 

Now, I've designed a new file with the same name, but the new file data source is SQL Server Analysis Service.

I uploaded it to the service, and all still work fine. (the data stored in the SQL Server Analysis Service in that case).

 

Since I'm using RLS + embeded, I found out that SQL Server Analysis Service require another configuration,

So I tried to roll back and re-publish the SQL based PBIX.

 

Now, the dataset is still associated to SQL Server Analysis Service althogh the new PBIX is not, and no matter waht I'm doing, it is not override the existing association.

 

Here is the msg: "This dataset connects to a SQL Server Analysis Services Tabular database & is always up to date. You don't have to schedule a refresh on this dataset." and it still the same when I re-publish the new file trughout the PBI desktop, nor PBI service.. 

 

Best Regards,

David

 

 

 

Highlighted
Community Support Team
Community Support Team

Re: Override PBI SSAS-based dataset with Service-based model

Hi @BILive,

 

Sorry for the delay.

 

Yes, if you want to use RLS for SQL Server Analysis Service, you should create the roles in SSAS not in Power BI Desktop.

 

Based your information, if I understand your scenario correctly that you have published the report which data source is SQL Server Analysis Service to Power BI Service, and then you configured the RLS in SQL Server Analysis Service and re-publish the report to Power BI Service, but it not override the existing report?

 

In addition, do you add the SQL Server Analysis Service data source to on-premises data gateway ?

 

Best  Regards,

Cherry

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