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.
Hi,
Am currently moving one of our company's dashboards from Excel over to Power BI, one tab has a connection to a cube data source using analysis services.
Because it usually has quite a few slicers with different demographic data, this translates to many, many rows when importing to Power BI and it will not apply changes (adding items / dimensions to the table in power bi) in order for me to get on with building the dashboard slide.
Is there either a way to increase the amount of data / raise the time out limit of pulling this data from our servers, or another work around (preferably not through another spreadsheet or anything, I would like to have this so I don't need to update it at the beginning of every month)
Thanks
Fraser
Hi @fraserwatt,
In your scenario, I would suggest you connect to SSAS in a live connection. It will keep dimension attributes, measures, hierarchies. For more information, please refer to this article:
Connect to SSAS Multidimensional Models in Power BI Desktop
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
What are the data limits while connecting to a cube in import mode?
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.
User | Count |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |