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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
bigchippah
Helper I
Helper I

Adding PowerBI dataset to my gateway: "invalid connection string"?

Do I actually have to add my data sources to the Gateway twice?  First as a "thin" file with data-only, and second as a PowerBI dataset?  If so, I'm really struggling with that second part:

 

1. I have my dataset in Desktop.  No visuals, just the data.  Published this to the Service and added all of my data sources to my Gateway.  So far, so good.

 

2. Created a new file in Desktop and connected to my PowerBI dataset.  Built some visuals and published this new file to the Service.  Now it's asking me to add my Power BI dataset to the cloud (as Analysis Services) and I keep getting an error:

 

Unable to create data source. An invalid connection string has at least one of the passed arguments which does not meet the parameter specification. Please check the data source connection string.

 

Authentication failed: User ID and Password are required when user interface is not available.

 

When adding the Power Bi datase to the gateway, Authentication Method is Windows and uses my work login.  Privacy level is "Private."  I don't have anything input in the "Map user names" section (EffectiveUserName is selected).

 

I went into my "Golden Dataset", looked at my source, and permissions seem fine.  What am I missing?

5 REPLIES 5
edhans
Super User
Super User

Did you add just one dataset to the new PBIX, or is it a composite model using DQ for AAS/PBI Datasets with other data? If the latter, is this a Pro or Premium workspace? If Pro, you must enable build permissions on the dataset. That restriction was removed from Premium a few months ago and will be removed from Pro, but it hasn't been done yet.

If it is just a single dataset, and there is NOTHING in the Power Query view (100% empty) then none of this should be necessary. When you write a report on another dataset, there is nothing to do once published. No refreshes, no nothing. It just looks at that dataset when a user refreshes a report.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Hi @edhans!  Thanks for the reply.

 

This is a composite model: there is my DirectQuery PowerBI dataset, as well as several Excel files in OneDrive.  It's a Pro workspace.

 

I'm the administrator for all of my datasets.  Do I still need to enable build permissions if I've built all of this stuff from scratch?  And if so, how do I go about doing that?  I've looked at the dataset, as well as the report and I am listed under "People and groups with access" with "Admin(Owner)" Permissions.

See this article on build permissions. The fact that you need it today in a Pro environment isn't the intended effect, but the composite model feature is still in preview, so it isn't done. That is why it is necessary.

Build permission for shared datasets - Power BI | Microsoft Docs



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

I tried to use this exact page before and couldn't figure it out. 

 

On second look (and managing to find my way to a page that actually says "Read,Build" Permissions), I see myself as Admin/Owner.  Shouldn't the below criteria apply to me?

 

Members of a workspace with at least a Contributor role automatically have Build permission for datasets in that workspace, and permission to copy a report.

You are going to have to provide some screenshots of exactly what you are doing every step of the way. I am not sure we are 100% using the same terminology. For example "Do I actually have to add my data sources to the Gateway twice?  First as a "thin" file with data-only, and second as a PowerBI dataset?" actually makes no sense in Power BI. You cannot add it as a thin file. Period.

I just spent 15min discussing with someone why they were getting a requirement to add their connection to a dataset to a gateway when it shouldn't be necessary. Turns out once they shared screens, they were connecting to a dataset in a SAP HANA database, which is not a Power BI dataset, and the converstation took a very different turn and became productive.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors