Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello ,
I have a Power BI report who pulls data from SSAS MDS cube. The report works fine when on power BI desktop, but fails with the following message:
Hello,
We did get he same error when using Power BI Javascript API and Power BI Embedded. This happen when you put too many filters on javascript side. Any idea or maybe a fixed planned ? We of course raised a incident to MS support.
const advancedFilter: pbi.models.IAdvancedFilter = { $schema: "http://powerbi.com/product/schema#advanced", target: { table: "Store", column: "Name" }, logicalOperator: "Or", conditions: [ { operator: "Contains", value: "Wash" }, { operator: "Contains", value: "Park" }, { operator: "Contains", value: "Shanghai" }, { operator: "Contains", value: "China" } Etc............. ], filterType: pbi.models.FilterType.AdvancedFilter }
Regards.
Hello,
Im having the same issue, any solution was found?
Thanks
Hi @sachin1234,
Since your datasource is ssas and you published the report to service, you need a gateway to manage the your data. Can you ensure you are correctly setting the on-premise gateway at service side?
Reference link:
Manage your data source - Analysis Services
In addition, if above is not help, can you share some detail content? It will be help for troubleshooting.
Regards,
Xiaoxin Sheng