Forum Discussion

Michael_Mertens's avatar
Michael_Mertens
Icon for Resolver I rankResolver I
5 years ago
Solved

Data Gateway necessary?

Hi,   I'm wondering whether it is possible to load and refresh a Power BI Premium dataset through the XMLA endpoint without a data gateway. This would mean that data would only be pushed to the da...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Michael_Mertens ,

     

    I didn't work with the OOL bindings, but as far as I understood you can just do changes of the process in a more granular way. So you can change parts of the M code or native query, you could process a single day or full process or change the data source to another, already existing data source.

     

    But from my understanding all of that are just more granular adjustments to the way the data set is processed. What stays the same is that when your data set needs a gateway you have to set it up and configure it upfront. So from my understanding everything you mentioned stays the same, you have now just better options to tweak the process with XMLA endpoints.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
Michael_Mertens's avatar
Michael_Mertens
Icon for Resolver I rankResolver I
5 years ago

Hi Denis, 

 

thank you for the answer. This is also my understanding. However, with the latest explanations in the Power BI blog about XMLA functionalities (like OOL Bindings) , I was wondering whether XMLA can do more than I know.

If it were possible to tunnel the connection to the source database through XMLA, this would be an alternative to a gateway. But it is probably not possible...

 

Regards

Michael

 

 

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Michael_Mertens ,

 

I didn't work with the OOL bindings, but as far as I understood you can just do changes of the process in a more granular way. So you can change parts of the M code or native query, you could process a single day or full process or change the data source to another, already existing data source.

 

But from my understanding all of that are just more granular adjustments to the way the data set is processed. What stays the same is that when your data set needs a gateway you have to set it up and configure it upfront. So from my understanding everything you mentioned stays the same, you have now just better options to tweak the process with XMLA endpoints.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis