Forum Discussion
Live connection with Maria DB
I have odbc connector from maria db webiste for power bi, i have connected it is showing import connection as it is not asking for any direct query so i believe that its import connection by checking all the three reports. model and relationship tab was there.
Can you guide me is it possible to make analysis services on top of maria db then i can connect live connection with power bi from analysis services.
Thanks and Regards
if you want direct query, you must start from the sratch, because direct query cannot by combined with other modes, only one server is possible, a there is many limitation in data model.
if you want use dedicated model in SSAS live connected from PBI, it is too complex to guide here, but can start here: https://docs.microsoft.com/en-us/sql/analysis-services/tabular-modeling-adventure-works-tutorial or https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-modeling-adventure-works-tutorial