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

Watsky's avatar
Watsky
Solution Sage
3 years ago

Are you admin on your Power BI tenant? If so check and make sure that it is enabled on there. If it is enabled try turning off the Power BI Desktop-InfrastructureUpdate this has been known to cause issues in Power BI Desktop. For what it's worth, this is what I have turned on in Preview Features. 

You should see a message like this at the bottom of your Power BI Desktop window. 

Let me know what happens...

 

wshalex123's avatar
wshalex123
Helper III
3 years ago

Hey Watsky 

iam now on my private PC, away from office. 

 

I opened my live connection file and it showed me my connected dataset like in the office (was not sure if this is possible when iam not in the gateway).

 

I unselected this checkbox and now iam completly unable to open PowerBI.

Now, after a restart of PowerBI (And the PC), i cant open PowerBI anymore. The loading screen is showing for 2-3sec, then it's closing again...

 

 

What happened? 

 

P.S.: My settings still look like this, just the one checkbox "infrastructure update" is turned off.