Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Relationship (Direct Query)

Hi,

 

I am unable to create relationship with the fact table which is in the server (Direct Query)

 

It shows as blank. Help Appreciated! 🙂

 

mandar_manik_1-1640513871383.png

 

 

1 ACCEPTED SOLUTION
bcdobbs
Super User
Super User

You need to set the tables storage mode to dual so that power bi treats it as a composite model:

 

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode#constraints-on-direct... 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

2 REPLIES 2
v-yanjiang-msft
Community Support
Community Support

Hi @Anonymous ,

I wonder how many rows are in your fact table, there is a one-million-row limitation for direct query mode.

Please have a good look at this document to know more about the limitations for direct query.

  • There is a one-million-row limit for returning data when using DirectQuery. The limit does not affect aggregations or calculations used to create the dataset returned using DirectQuery, only the rows returned. For example, you can aggregate 10 million rows with your query that runs on the data source, and accurately return the results of that aggregation to Power BI using DirectQuery as long as the data returned to Power BI is less than 1 million rows. If more than 1 million rows would be returned from DirectQuery, Power BI returns an error.

Best Regards,
Community Support Team _ kalyj

 

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

bcdobbs
Super User
Super User

You need to set the tables storage mode to dual so that power bi treats it as a composite model:

 

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode#constraints-on-direct... 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors