User Profile
dalton_stegner
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Re: Using Tabular ProviderDataSource with On Premise PowerBi Data Gateway DB Connection
Sorry to clarify on top of your sample code, I mean how could I create a connection string for a ProviderDataSource for a PowerBI Gateway? My issue stems from powerbi not being able to connect to my database since powerbi is outside the vpn of our database hosted in Azure. All samples I have found are for local host which is not my use case. Or is my only option to expose a database with a user account and allow that account to log in.3.5KViews0likes0CommentsUsing Tabular ProviderDataSource with On Premise PowerBi Data Gateway DB Connection
I am attempting to use Microsoft.AnalysisServices.Tabular .NET library in an attempt to programmitcally generate a Tabular model in powerbi. I am able to upload my table structure just fine. My issue is with my ProviderDataSource for my database. All documentation examples show using "localhost:port". I need to access an azure hosted database. Currently we have non programmitically generated datasets that use the on premise data gateway to fetch data. I believe that is my only way at this time to fetch data for my generated set as well. My question is how to select the gateway as a data source in c#. To the best of my understanding there is not a connection string. Even in hosted power bi I am unable to 'discover data sources'. Here is an example of the docs I am attempting to follow: https://docs.microsoft.com/en-us/analysis-services/tom/create-tables-partitions-and-columns-in-a-tabular-model?view=asallproducts-allversions3.5KViews0likes9Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.