Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |