Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
... 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!
Solved! Go to Solution.
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:
"Get Data" from this sharepoint list
Hmm that's odd. What version of Power BI are you using? Is it that it just hangs like this or does it crash?
Proud to be a Super User!
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.
Proud to be a Super User!
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
Proud to be a Super User!
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)
["New" live Connection]
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
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...
Proud to be a Super User!
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!!
Proud to be a Super User!
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?
I can't say I know German all that well but isn't Verwaltungsportal the Admin Portal?
Proud to be a Super User!
I thought that too, but for me it's nearly empty.
Ah so that means you are set as Admin but not set as Capacity Admin... 😞 Keep me in the loop on Monday. My hope is that the feature is just not turned on.
Proud to be a Super User!
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..
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.
Proud to be a Super User!
Hey @Watsky
sorry for the late response, i was out of office the whole week. So to get along with this topic...
The first setting you sent me is enabled in my organisation:
For the second setting i need PowerBI Pro (Even tho i have the test version of powerbi pro currently running it seems i still have to buy it).
... is this setting this important to get the report running? Would be a shame when i buy pro and it's still not working afterwards haha.
Cheers,
Alex
Hey @wshalex123,
According to Microsoft, it is needed.
See Verwenden von DirectQuery für Datasets und Analysis Services (Vorschau) - Power BI | Microsoft Learn
Proud to be a Super User!
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:
"Get Data" from this sharepoint list
iam checking this with the orgnisations admin. Thank you very much for know!
I'll try again on monday.
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.
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |