cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

publishing PBIX report that use live "Power BI->Power BI datasets" data // supported ?

Hello,

 

i'va a "master" PBIX that define the model that's published to my tenant pbi service, i've a PBI Pro licence.

 

then, i constructed some reports, that get their data from the model, live. did that by using "get data"->"Power BI"->"Power BI datasets" under pbi desktop.

 

everything is fine, and I publish them to the pbi servcie, I can use them, the scheduled refresh to my "master" reflect to the other reports connected to it.

 

BUT, when i publish this PBIX to my onpremise "PBI report server", I'm unable to use it. i'm unable to find an authentication model that works. I keep getting into my server log file:

 

 System.ArgumentException: The integrated security 'ClaimsToken' is not supported for native connections.

(if i use Integrated Security=ClaimsToken into my report->data source)

or 

 

System.ArgumentException: The integrated security 'Basic' is not supported for native connections.

(if i use Integrated Security=BASiC  into my report->data source)

 

is that scenario supported ? what should i use as the "Integrated Security" property into my dsn ?

the one I have right now is the one that set by uploading the PBIX into my report server.

 

thanks

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors