Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I 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?......
Hi @BILive,
I 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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.