Forum Discussion
Solved
Data sources: Live & SQL connection
Hi everyone, i got a PowerBI Desktop report which is getting it's data from a SQL Server and one Excel file. My goal: Show the latest messages posted in a curtain teams channel in this Power...
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
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