Forum Discussion

Prabha45's avatar
Prabha45
Helper III
2 years ago

Field Parameters - Live connection

I had made a live connection to a cube and need a field parameter functionality. So, I changed the connection from live to Direct query. I made the field parameters and created a slicer and table wit...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Prabha45 

 

Based on the screenshot you provided, it indicates that the dataset contains calculated tables or columns that reference remote tables.

 

This is a known limitation when using the DirectQuery schema, especially for calculated tables or columns that rely on Analysis Services connections.

 

You can try the following ways to solve the problem:

 

Use the Analysis Services connector to import the data in instead of using DirectQuery.

 

Check for calculated tables or columns in your dataset that depend on remote tables and consider removing them or changing their dependencies.

 

See the specific limitations of calculated tables and columns in power bi service and make changes to your dataset accordingly.

 

Solved: Error message on publishing: "This dataset contain... - Microsoft Fabric Community

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Prabha45's avatar
Prabha45
Helper III
2 years ago

Thanks for the reply.
The calculated table automatically gets created when we created field parameters. 
The data is huge which will not support import mode.
Power BI don't allow to create field paramters in live connection. So, I changed it to direct query and created field parameters. When I publish I get the above error and I'm not able to see the data in service.