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

Hello Watsky 

 

thank you for your help! I digged into this matter. Now, i dont know how to come forward.

 

Current situation:

 

["Old" published report] -> (import - connection)

  • Sources:
    • SQL Server
    • Excel sheet

["New" live Connection]

  •  Connected to
    • ["Old" published report]

 

Problem:

 

... in the section "Using DirectQuery for live connections" of the link you sent me it says i need to change the model of ["New" live connection], in order to "add a local model" afterwards.

 

Then, i should be able to connect to my Streaming Dataset, or am i wrong?

 

... however, changing the model is not possible in my live connection. I found a post in the community which has the same problem. When reading it, i still don't know why it's not working for me. Link:

Can't Make Changes to Model After Connecting to Da... - Microsoft Power BI Community

 

May you help me out one more time?

 

Thank you very much!

 

 

 

wshalex123's avatar
wshalex123
Helper III
3 years ago

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