Forum Discussion
Power BI Desktop Loads Data forever
I'm trying to import data into Power BI desktop from an analysis services data source on premise. We don't have a data gateway set up, so the data needs to be published with the reports. It takes FOR...
Unfortunately, the data gateway will not be deployed for probably another year at my organization and it is out of my control. But I need to be able to create reports in the meantime. It just seems that Power BI is interacting with the cube differently than Power Pivot does and I want to figure out if it is by design or I have some setting wrong on my Power BI setup.
Oh! And I need to add that if I connect directly to the fact table as a SQL Server type of connection, the same exact query runs in a few minutes. At first that sounds like an issue with the cube itself, but interacting with it in Power Pivot as a cube works fine, which makes me think it's the way Power BI is interacting with it.