Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
When I want to retrieve the table objects in my query using #shared, I get null values
How can this be solved?
Yes. I'm using a dataflow in Fabric
You mean a Dataflow Gen2 ?
This isn't the issue. I'm using powerquery online and the '=' sign isn't used in that environment. Using the '=' sign is causing an error message.
Power Query Online? Like, in a dataflow?
looks like you are missing the = sign
= #shared
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 5 | |
| 5 | |
| 4 |