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
JGroothedde
Resolver I
Resolver I

Can't add Power BI dataset to local model and vice versa (Premium per user workspace)

Hi everyone,

I am dumbfounded. For a while now it has been impossible for me to connect Desktop to a Premium per user workspace, but only if a local model is involved. What's going on?

For example: when i create a new report in Power BI desktop and connect to my Power BI Dataset that's hosted in a Premium per user workspace, all is fine. Works perfectly. Once i try to add a local model to add another source, even an Excel file, the message below pops up..

JGroothedde_0-1680527900476.png

 

 

Same thing happens when i turn it around. I create a desktop file, add an Excel source to it and then try to connect to a dataset in a premium per user workspace and i get the same message. Very frustrating honestly. Interestingly, this does not occur when connecting to a dataset in an Pro workspace.

What's the deal? Anyone know whether this is a known issue or how to fix this?

 

1 ACCEPTED SOLUTION
JGroothedde
Resolver I
Resolver I

Well. I figured it out. For anyone having the same issue: in our case the culprit was a trailing space behind the name of the dataset. I.E: datasetname .pbix instead of datasetname.pbix.

 

Removing the trailing space solved the issue we've been having for a couple of months now. No wonder i couldn't find anything about it. 

Cheers @amitchandak  for the suggestions. I hope this helps someone else someday, lol.

View solution in original post

3 REPLIES 3
JGroothedde
Resolver I
Resolver I

Well. I figured it out. For anyone having the same issue: in our case the culprit was a trailing space behind the name of the dataset. I.E: datasetname .pbix instead of datasetname.pbix.

 

Removing the trailing space solved the issue we've been having for a couple of months now. No wonder i couldn't find anything about it. 

Cheers @amitchandak  for the suggestions. I hope this helps someone else someday, lol.

amitchandak
Super User
Super User

@JGroothedde , first add a dataset to the empty power bi file, Then make it a direct query using the option in the modeling tab.  And then add an excel file

 

Make sure the login on the desktop has access to dataset

Hi there Amit,

Cheers for the suggestion, unfortunately this doesn't change the outcome. I have verified that desktop has access to the dataset, it easily connects to it. Issues arise when trying to make changes to the local model. I get the screen where you can select the tables you want and then the screenshot above. It fails creating a local model. Again, it works fine when the dataset is hosted in a Pro workspace.

 

I'm stumped haha

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