Search found 2 matches

by RuthBallinger
Wed Jul 01, 2020 9:24 pm
Forum: Power BI Desktop/Service
Topic: Reset TODAY
Replies: 0
Views: 335

Reset TODAY

I have some BI reports that include visuals such as sales in last 7 days etc. I want to create a snap shot report dated end of May for year end including all my data to the end of May. But these visuals then report the last 7 days from today not from the end of May. I have lots of measures that use ...
by RuthBallinger
Wed Jun 17, 2020 1:30 am
Forum: Power Query
Topic: Excel Connection String
Replies: 1
Views: 305

Excel Connection String

Using Get data from excel will generate a string like Provider=MSOLAP.8;Integrated Security=ClaimsToken;Persist Security Info=True;Initial Catalog=sobe_wowvirtualserver- [ ####################] ;Data Source=pbiazure://api.powerbi.com;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error...

Go to advanced search

cron