Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi Guys,
I am bringing 2 Power BI datasets having dynamic RLS and when I do the data modeling, then I get the following error:
"To filter a remote power bi data source or Analysis Services data source by reaching more than one table within the remote data source, which is not supported"
Any help?
Hi @ashwinijain932 ,
What is your connection method? Have you converted to Direct Query mode? What did you do when this error occurred? Please have a check.
Since the functionality is currently in preview, you must first enable it. To do so, in Power BI Desktop go to File > Options and settings > Options, and in the Preview features section, select the DirectQuery for Power BI datasets and Analysis Services checkbox to enable this preview feature. You may need to restart Power BI Desktop for the change to take effect.
Using DirectQuery for Power BI datasets and Azure Analysis Services requires your report to have a local model. You can start from a live connection and add or upgrade to a local model, or start with a DirectQuery connection or imported data, which automatically creates a local model in your report.
Considerations and limitations
More details: Using DirectQuery for Power BI datasets and Azure Analysis Services (preview)
I have also found a similar psot, please refer to it to see if it helps you.
Prolem in making Relationship in Hybrid model.
If I have misunderstood you meaning, please provide a screenshoot with the error and more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 37 | |
| 33 | |
| 29 | |
| 27 |
| User | Count |
|---|---|
| 133 | |
| 104 | |
| 61 | |
| 59 | |
| 55 |