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

P.S.: i already checked this checkbox in my live connection

 

 

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.

     

     

     

     

  • wshalex123's avatar
    wshalex123
    Helper III
    3 years ago

    Hey Watsky 

     

    PowerBI is running again, with your preview selection 🙂 

     

    so far so good  ✔️

     

    ... i still can't make changes to this model.

     

     

    ---------------------

     

    what do you mean with your sentence: "Are you admin on your Power BI tenant? If so check and make sure that it is enabled on there"? 

    With the "tenant" you mean PowerBI in my organisation? Yes iam Admin there. What sould i enable where? 😄 

     

     

    Thanks for your support!!

     

     

    • Watsky's avatar
      Watsky
      Solution Sage
      3 years ago

       

      • wshalex123's avatar
        wshalex123
        Helper III
        3 years ago

         

        maybe iam blind but i can't find the admin portal in my PowerBI Service settings. Maybe thats because iam a admin in powerBI but not an admin of the whole organisation of the company?