Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hello,
I run a direct query connection but it does not let me add calculated columns and transform the data in Power Query?
Believe this is a setting so would appreciate a work around or a solution to build a model on direct query connection.
Hi @Luukv93
It is possible to add calculated columns or do some actions in query editor when there's a direct query connection. But there're some limitations for it. Below is the articles about these limitations for your reference.
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
http://radacad.com/directquery-live-connection-or-import-data-tough-decision
Regards,
Cherie
Hi, @v-cherch-msft
We have production lines that produce products. The labeling engine records all packages produced in a sql database. I would like to know if it is possible to stream that data to a dashboard so we can monitor this process real -time
Hi @Luukv93
Below are the posts for your reference.
https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming
Regards,
Cherie
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 51 | |
| 37 | |
| 35 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 65 | |
| 39 | |
| 33 | |
| 23 |