Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have two things I'd like to achieve:
- get the most recent data from Stream Analytics to be as up-to-date as possible
- provide the historical data (we store them in a Cosmos DB).
The connection to the Stream Analytics in realtime carries the disadvantage that it is limited to 200.000 rows, data will be dropped FIFO.
To overcome this I decided to load older data from the Cosmos DB into the model. Because these are continously increasing measurement data without changes in older data, I assumed incremental refresh would be the most efficient solution.
Therefore I created a dashboard in Power BI Desktop and implemented the incremental refresh.
Additionally I configured a PowerBI Output in my stream analytics jobs, so the data are pushed into a dataset in the Power BI service.
I can add this dataset via the Power BI Datasets Button and use those data as an additional data source. This works fine (iirc I had to activate an option in the previews setting in the settings menu).
Looks fine so far, pretty much what I wanted, the live data refresh continously. But if i publish this into the Power BI service all visualizations using these live data are labeled as unavailable. What am I missing? Did I miss to set some access rights?
kind regards!
Solved! Go to Solution.
Well, to finalize the topic here:
I contacted MS Support and we met via video call. When I wanted to show the problem, it was magically solved. I do have NO idea why it suddenly worked. Only thing that changed is Google Chrome, which updated itself after my last check-in that it didn't work and the video call with the support team.
Hi @Micado ,
Check whether there are some limitations in your visuals:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
Besides have you configured the data source in Service?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi,
thx for your response. As stated, it is a dataset, configured in Azure Stream Analytics and directly pushed into a workspace into PBI service.
Opening it in Power BI Desktop (from the option "Power BI-Datasets") works, I can create visualizations and they show the data in Power BI Desktop.
But publishing it (into the same workspace the datasets is located) breaks the visualisation with the note "Cannot load data".
That's unexpected, to say the least 😄
Hi @Micado ,
Have you checked the limitations and considerations below?
When using the Power BI service live connection, there are a few limitations and considerations to keep in mind.
Check the reference below:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Thx, let's get through the limitations, but should all be fine.
Hi @Micado ,
Then let me ask a question may be a little foolish,have you checked the account in Service and desktop?Whether they are the same?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi, that ain't a foolish question, it's just ruling out avoidable problems - and I didn't check it because a relied on the fact, that my company is really ruling the SSO game - and indeed they are: Both accounts I'm signed in with are the same.
Hi @Micado ,
If so,I would suggest you create a support ticket via below link and our relevant personnel will help to handle it.
https://powerbi.microsoft.com/en-us/support/
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Well, to finalize the topic here:
I contacted MS Support and we met via video call. When I wanted to show the problem, it was magically solved. I do have NO idea why it suddenly worked. Only thing that changed is Google Chrome, which updated itself after my last check-in that it didn't work and the video call with the support team.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |