search

R0tenur / visualization

MIT License
169 stars 25 forks source link

Error in ADS when I press Schema Visualization #102

Open eq2home opened 1 year ago

eq2home commented 1 year ago

Cannot connect to the database due to invalid OwnerUri (Parameter 'OwnerUri')

antimirov commented 1 year ago

Same error here. JFYI, I'm using MFA to connect to my DBs

jasonlmc commented 7 months ago

When connecting to power bi sql server db I get the following error: An error occured! DISMISS Status: ERROR Could not build mermaid from db response Raw data: "\"Db-response:\n []\""

Found a bug? Report it here: https://github.com/R0tenur/visualization/issues

R0tenur commented 7 months ago

@jasonlmc

Are you able to run this query? https://github.com/R0tenur/visualization/blob/master/backend%2Fsrc%2Frepositories%2Fmssql.repository.ts#L148

jasonlmc commented 7 months ago

Jens, 0 Records are returned from both queries. Probably because we are using the model database and views.

Jason

On Sun, Dec 10, 2023 at 3:10 AM Jens Hunt @.***> wrote:

@jasonlmc https://github.com/jasonlmc

Are you able to run this query?

https://github.com/R0tenur/visualization/blob/master/backend%2Fsrc%2Frepositories%2Fmssql.repository.ts#L148

— Reply to this email directly, view it on GitHub https://github.com/R0tenur/visualization/issues/102#issuecomment-1848903221, or unsubscribe https://github.com/notifications/unsubscribe-auth/AFCCJQ5BOHONQ7LKWFMDPW3YIV36VAVCNFSM6AAAAAAQDLB2TOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNBYHEYDGMRSGE . You are receiving this because you were mentioned.Message ID: @.***>

bruce-dunwiddie commented 7 months ago

Jens, 0 Records are returned from both queries. Probably because we are using the model database and views. Jason

Can you please explain what you mean by "power bi sql server db" and "using the model database and views"?

I don't currently recognize anything as a "power bi sql server db", as any kind of standard setup.

"model database" normally means a system database that contains the contents that will get copied any time a new database is created, so I don't quite understand what you mean that you're using it, and especially the views. Did you add user tables and views to model?

Can you use literal database names to explain your situation?

What are you trying to visualize?

Bruce