Forum Discussion

wshalex123's avatar
wshalex123
Helper III
3 years ago
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...
Need Help
  • wshalex123's avatar
    wshalex123
    3 years ago

    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: 

     

    1. Create a Flow via Power Automate

      When a Teams message in a channel is posted -> create a new item in a sharepoint list

    2. In PBI Desktop: 

      "Get Data" from this sharepoint list

       

    Watsky

wshalex123's avatar
wshalex123
Helper III
3 years ago

Good morning Watsky !

 

Good news, iam now admin and can see the settings.

Bad news, the setting is enabled and the issue is still the same..

 

 

 

 

 

Watsky's avatar
Watsky
Solution Sage
3 years ago

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.