Forum Discussion
Data sources: Live & SQL connection
Hey ,
probably it would work with this setting. We haven't purchased yet and so this setting is not available for me and i cant test it.
However, i found a very easy workaround for my concern which might be useful for future visitors:
- Create a Flow via Power Automate
When a Teams message in a channel is posted -> create a new item in a sharepoint list - In PBI Desktop:
"Get Data" from this sharepoint list
- Create a Flow via Power Automate
Good Morning wshalex123,
Sine you're Admin now can you check if this setting is enabled?
also check that XMLA is enabled for at least read (not set to Off). You will find this under the capacity settings under Workloads.
Hey Watsky
sorry for the late response, i was out of office the whole week. So to get along with this topic...
The first setting you sent me is enabled in my organisation:
For the second setting i need PowerBI Pro (Even tho i have the test version of powerbi pro currently running it seems i still have to buy it).
... is this setting this important to get the report running? Would be a shame when i buy pro and it's still not working afterwards haha.
Cheers,
Alex
Hey ,
probably it would work with this setting. We haven't purchased yet and so this setting is not available for me and i cant test it.
However, i found a very easy workaround for my concern which might be useful for future visitors:
- Create a Flow via Power Automate
When a Teams message in a channel is posted -> create a new item in a sharepoint list - In PBI Desktop:
"Get Data" from this sharepoint list
- Create a Flow via Power Automate
Hey wshalex123,
According to Microsoft, it is needed.
See Verwenden von DirectQuery für Datasets und Analysis Services (Vorschau) - Power BI | Microsoft Learn