DirectQuery Dataset Need Help

[Anonymous]

Hey guys,

I'm working on an PowerBi report with lots of interal Data.

Therefore i have a DirectQuery to an existing report and imported some other excel tables.

This report is freaking huge but for my new report i only need 4 tables out of it.

Those 4 Tables are connected differently then i need them, but because its a DirectQuery connection i cant change those relationships.

Is there an easy way around, something like i copy those 4 Tables and create then my own relationships?

Sincerley 

Jonas

[Anonymous]

Hi @Anonymous ,

Based on my test，when we use DirectQuery to connect to the Power BI dataset，we can delete unneeded tables， we can create relationships with excel tables in Import mode, but we cannot create or delete the relationship between tables in DirectQuery mode.

My suggestion is that if possible, you have access to the data source, you can create a new report by connecting to the data source using the desktop.

Best Regards,

Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

Thanks for your answer @Anonymous,.

I dont have access to the data source. They are stored on an internal server and the dataset i'm using for my directquery is already connected with directquery and a gateway to the server, because the dataset needs to refresh daily with around 100GB of production data.

[AllisonKennedy]

@Anonymous Do you need all the rows in the tables? Dataflows might help here so you can pull in the individual tables instead of needing to reference the entire dataset.

[Anonymous]

Thanks for your quick answer @AllisonKennedy 

Sorry for answering now, wasn't working the last days and had to write some emails to collegues about PowerBI Premium.

I need all of the rows in the tables, they get filterd in specific visuals with slicers.

Is there another way than Dataflows, because i wont get a premium account in my company.

[AllisonKennedy]

@Anonymous  You shouldn't need premium for dataflows (though it does give you more options for updating). Basically, Dataflows enables you to create single table/query references that you can relate with custom relationships, whereas Datasets must be pulled in all the tables.

[Anonymous]

@AllisonKennedy 

Thanks for your answer and your patience with me.

What I'm doing wrong when the Create Datafow isn't showing up for me?

[AllisonKennedy · Accepted solution]

@Anonymous  Your screenshot is from My Workspace, which can't have dataflows:

You need to create a New Workspace (or use an existing one -sometimes you may need to ask IT to create the workspace for you depending on your company's policies). In a Power BI workspace (that's not 'My Workspace'), you'll see this menu for New items: