Forum Discussion
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 PowerBI Desktop report
- I created a Streamingdataset (push) in POwerBI Service, where Power Automate sends the data to. (working)
- I can see these latest messages from teams in the Steaming Dataset in PowerBI Service
... now i want to connect the Streaming Dataset to my PowerBI Desktop report
When practising this it shows following error (translated):
"The live mode connection option is disabled for this file because it already contains data from another data source. You cannot browse data live in the same file and connect to other types of data sources. Create a new file to browse data live."
... it seems a live connection is not working with other data sources.
Still, iam convinced that this has to work somehow.
Does anyone know a different solution to get this working? I haven't found any other solution in the web.
Thank you very much!
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
20 Replies
Hiya wshalex123
The error you are receiving is correct. Leaving the live connection in the same format will limit your ability to add other datasets.
Since this connection is a live connection, left-navigation and modeling are disabled. You can only connect to one dataset in each report.See - Connect to datasets in the Power BI service from Power BI Desktop - Power BI | Microsoft Docs
As a possible workaround, you could change to a local model and connect via Direct Query. This feature would need to be enabled on the Power BI Service by a Power BI Admin.
See - Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs
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!
P.S.: i already checked this checkbox in my live connection
- Sources:
Hmm that's odd. What version of Power BI are you using? Is it that it just hangs like this or does it crash?
Here, iam using Version 2.108.997.0
It tries to start and crashes after a few seconds...
Try uninstalling and reinstalling Power BI. I'm thinking something got corrupted as it should load fine without the infrastructure update loaded.
