Forum Discussion
Azure Data Catalog cannot open a Power BI report using SSAS data source.
Could you please go to Query Editor and check which cube are you connecting from PBI Desktop? Then verify that the cube is still there by connecting to the same database using a different tool (SSMS or Excel). It is better to provide a screenshot or video about the queries and connection.
Best Regards,
Herbert
I've actually validated the same results from both tabular and mult-dimensional models. I did open a ticket with Microsoft to get the issue resolved but they are now telling me that this is correct behavior and that to open a Power BI report using a SSAS based data source you'll need to import the model as opposed to connecting live. Obvsiouly this solution only works for very very small SSAS models. I'm really hoping that this gets corrected since this functionality is key to our ADC usage.
We are a large government department who are in the process of implementing Azure Data Catalog (or not) - All of our connections to Tabular models are "connect live" due to security restrictions.
We have an urgent call with MS to discuss this issue in the comming days. It seems odd to me that you might as well not register a data asset if it exceeds a manageable size for import.
