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,
do power BI can 'get data' from data source that is not tabular? are there are any constraints?
thanks
Solved! Go to Solution.
Power BI Desktop internally creates temporary Aanalysis Services Tabular/PowerPivot model database for each created .pbix file. That's the reason it always show data in tabular way. Please refer to articel below:
Connect to Power BI Desktop Model from Excel and SSMS
Regards,
@MP_123 can you explain more about what you mean, provide an example of the data you referring to
Proud to be a Super User!
i am exploring PBI and i just want to know whether there are constraint on the data which PBI expecting to get.
whether it should be tabular only, bacause as i see the 'query editor' on pbi desktop show the data in a tabular way
thanks ! @vanessafvg
Power BI Desktop internally creates temporary Aanalysis Services Tabular/PowerPivot model database for each created .pbix file. That's the reason it always show data in tabular way. Please refer to articel below:
Connect to Power BI Desktop Model from Excel and SSMS
Regards,
@MP_123 you can pull basically what ever you want into power bi, it becomes a tabular model in power bi, but what it does before power bi isn't restrictred by power bi it just depends on how you doing things.
Proud to be a Super User!
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |