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
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 wshalex123,
According to Microsoft, it is needed.
See Verwenden von DirectQuery für Datasets und Analysis Services (Vorschau) - Power BI | Microsoft Learn
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