You are really lucky for me, Patrick. Everytime I get stuck and get no idea what went wrong. Your video comes up with a clue! Thanks for saving my day!
I haven't run into this, but good to know. Emphasizes that best practice is to make sure all of the columns are property typed. Since it is also best practice turn off automatic detection of column types, it is even more important to check those manually before exiting Power Query.
I was excited to see this video, but I was unable to find any filter issues whatsoever. My issue was with only one of my Power BI Reports, the first one I ever created. Turns out, my report was still in 'My workspace'. I republished this in a new Workspace and the refresh now works!!! I didn't know there was this nuance with 'My workspace'.
Really happy with this video. Encountered the same issue. Had a 0/1 column that after refresh resulted in 0/-1. Report showed no data. Solved now. Thank you for always being so short and clear. Guys in a cube = TOP! You guys even beat ChatGPT :D !
I run into this 2 weeks ago. Never knew about the issue being documented I just realize this on my own. In the end, always declare what type of data you use, it will save you later down the line.
Okay so this didn't solve my issue BUT still giving you a like and subscribe because this is the first time I watched a "help" video that was EASY to follow and understand. Thank you so much!!!
Thank you so much for this video, encountered this exact scenario and wasn’t able to solve it and was driving me crazy! Did exactly what u said and fixed it straight away! Thank you! ❤
I have a refresh the data but data not show completely , but if i made any changes in power query then report is perfectly correct, every time in any change in working files then again same process we will be follow, where is discrepancies i don't know pls help me
Did come across this in using source as SharePoint list, had to do rls based on this column, fixed it using 1 and 0 in rls, got to know while testing. Good to know changing to Boolean solves it easily. Thanks for the tip
Bit of an outdated question here... this was my issue in the report, however by changing the type I'm unable to use my switch statement that was looking for "True" or "False" - how can I adjust this to look at the new True/False that is no longer text?
Thought this was the case for my report but mine is a bit different. Data shows in desktop, after uploading data in table and filters disappears, other tabs still show data. I have no filters in the page or table level. Any suggestions?
Is there ever a reason to keep the "any" data type from PQ? I've seen it break a simple card visual (when PQ steps auto-changed after I changed the source file, and I lost my type-change step). Makes me wish PBI Desktop would complain or even refuse to import columns with the "any" type. ?
Specific data sources have made this a problem before, with the SSIS catalog. While the actual server and all the databases were in the gateway source, the SSIS catalog data was not refreshing in the service but would work fine in Desktop. So I had to add it specifically to the gateway sources.
I am trying to display the data in matrix and the value is calculated column (combination of number and text). When I publish the data, it is visible in matrix but when a scheduled refresh is completed the data is vanished and we see empty matrix. I tried to check the datatype as well for Boolean values but didn't find any issue. Can you please help
This worked for me! My problem was that I had a column ("cancel_reason") which contained a "false" text. The format of the column in the PQ was alphanumeric. I proceeded to change to "text" and that fixed my problem.
I have a similar issue but instead of all my visuals going blank, my already created visuals still work but any new visuals or filters that I try to create end up blank/no data. Any suggestions?
Question, I have a week filter in my power BI report and by default this filter will have the week which is selected during the pulishing. is there any way to adjust this filter to take the most recent week every time we open the report ? ( with out creating additional filters to select)
Yes, 1 option is to add a flag (true/false) calc column logic in the date table and use it as filter. Logic could be something like, date[current week flag]= if (today's week number= week number of date table) then true else false. In filter, set this flag=true. Done Remember to add calc columns as close to the data source as possible.
@@Bharath_PBI Thank you. But, if I do this I won't be able to filter for previous week's data unless I change the filter to 'No' again right ? I want avoid this. Basically, I want to have my report show me the latest week's data but I should be able to see previous weeks data as well by selecting previous week. (But don't want use another filter like 'yes' and 'no) Does this make sense ?
@@Bharath_PBI This is how my filter looks : " Week No : 1 2 3 4.... " So, I want to be able to select any week I require but by default I want this to be filtered for most latest week dynamically
Hi Patrick, Is there any way to disable auto sorting the columns in Fields pane?... Because my table has 400+ columns and i want to add all those columns into table visual same as in my data source. If you have a solution , please do a video on it. Thanks Jaffer
Yes, that's something really useful. Also when you have hundreds of columns in tables, and when you try to setup relationship, it's a pain to search for the "from" and "to" columns in the manage relationship window.
2 Other scenarios i've run into: 1. Using a connector, like exhange, which has different outcomes between Power BI Desktop and the service. For exchange in particular, while on the desktop it uses on-prem exchange. When published to the service it uses exchange online. This is a problem if you don't use exchange online and there is no way to force your dataset to use the correct one. 2. Having a different database user account in your gateway than you are using on-premise. You could fall fowl of row level security where you get rows when refreshing on premise but not when the service makes a call.
Hi there, I have the same issue with a filter disappearing but the filter is based off the following measure. IF( MAX('Calendar'[Date])>=DATE(YEAR(TODAY())-1,MONTH(TODAY())-1,1)&&MAX('Calendar'[Date])
Hello @Patrick and all, greetings from Bangladesh. I felt in this problem and tryed to soled. Unfortunatly in particular Droopdown Colom of the Set of Activities (123_ABC) are not appear. So how I will fix the problem. Seeking urgent assistant. Would some one help me in soonest time. Thanks in advance
I am running into this problem now and am using 0 and 1 instead of true and false. If I update the desktop version and publish it works just fine. When the refresh runs overnight all my data is wiped out. Ideas?
I don't like to use boolean format because sometimes they fail when using it in a condicional dax when is published in an app. It works Wells in Desktop, in Power service but It brakes in the Power bi Apps. So I prefer to use text format, so It always works well
I ran into a situation where my visualizations seem to be ignoring parts of my data in Power BI Desktop. I can see the data in data view, and even when I slice directly to it, my visualizations don’t see it.
has anyone faced this problem ? - source, SQL server views - credentials to get data worked out perfectly - published to service - first of all there was an error ,,schedule refresh not supported for at least one of sorces,, after refresh this has changed - now I have greyed out credentials and I am not able to edit them thus, scheduled refresh is not available - have tried to edit in pbi desktop in data source settings credentials, even deleted and created again - no change - in pbi service under dataset I can see under Database - connection status ,, unable to connect,, - anyone any idea? Have tried also pbi commuity, no help - and no there is no need or a plan to use personal gateway
Different ways for different scenarios. Answer is It depends! 1) When there's thousands of countries (or cities) cardinality is high, whereas true/false column will always have a cardinality of 2 or 3, if nullable. 2) Performance (of filter, fetching values) will be good if you slice/filter on low cardinal columns 3) In some cases, business identifies certain things as flags, which is mostly true/false scenario, which Patrick's demo uses. I could think of these 3 at the moment.. Someone can add more to it.
You are really lucky for me, Patrick. Everytime I get stuck and get no idea what went wrong. Your video comes up with a clue! Thanks for saving my day!
THANK YOU!!!!!!! For 2 days I couldn't understand why my data "disappeared" after the refresh. I cannot believe how simple this was to FIX. THANK YOU!
I haven't run into this, but good to know. Emphasizes that best practice is to make sure all of the columns are property typed. Since it is also best practice turn off automatic detection of column types, it is even more important to check those manually before exiting Power Query.
Yes agree, for database sources, this shouldn't be a problem, but power query columns, yes definitely data profiling is required.
I was excited to see this video, but I was unable to find any filter issues whatsoever. My issue was with only one of my Power BI Reports, the first one I ever created. Turns out, my report was still in 'My workspace'. I republished this in a new Workspace and the refresh now works!!! I didn't know there was this nuance with 'My workspace'.
Really happy with this video. Encountered the same issue. Had a 0/1 column that after refresh resulted in 0/-1. Report showed no data. Solved now. Thank you for always being so short and clear. Guys in a cube = TOP! You guys even beat ChatGPT :D !
I run into this 2 weeks ago. Never knew about the issue being documented I just realize this on my own. In the end, always declare what type of data you use, it will save you later down the line.
Thanks Patrick! This video came in handy today, ran into the same issue and you came to my rescue!!
Okay so this didn't solve my issue BUT still giving you a like and subscribe because this is the first time I watched a "help" video that was EASY to follow and understand. Thank you so much!!!
Thank you very much, I had been looking for a solution to my problem for so long, I found it with you!
Thank you Patrick 🙂. You saved me just before Monday's meeting.
Thank you so much for this video, encountered this exact scenario and wasn’t able to solve it and was driving me crazy! Did exactly what u said and fixed it straight away! Thank you! ❤
Thank you! You saved me a few hours of frustration with this clear explanation!
I have a refresh the data but data not show completely , but if i made any changes in power query then report is perfectly correct, every time in any change in working files then again same process we will be follow,
where is discrepancies i don't know pls help me
Under your promoted headers there is a green line. Does it mean anything? Some of my columns are part green part gray
Did come across this in using source as SharePoint list, had to do rls based on this column, fixed it using 1 and 0 in rls, got to know while testing. Good to know changing to Boolean solves it easily. Thanks for the tip
Thanks Patrick. you are really amazing ! you saved hours of mine.
Bit of an outdated question here... this was my issue in the report, however by changing the type I'm unable to use my switch statement that was looking for "True" or "False" - how can I adjust this to look at the new True/False that is no longer text?
The fact that i wasted 1 hour of my worktime just to find out it was a filtering issue is just so depressing, thanks for the help!
Thought this was the case for my report but mine is a bit different. Data shows in desktop, after uploading data in table and filters disappears, other tabs still show data. I have no filters in the page or table level. Any suggestions?
Is there ever a reason to keep the "any" data type from PQ? I've seen it break a simple card visual (when PQ steps auto-changed after I changed the source file, and I lost my type-change step). Makes me wish PBI Desktop would complain or even refuse to import columns with the "any" type. ?
Specific data sources have made this a problem before, with the SSIS catalog.
While the actual server and all the databases were in the gateway source, the SSIS catalog data was not refreshing in the service but would work fine in Desktop. So I had to add it specifically to the gateway sources.
I am trying to display the data in matrix and the value is calculated column (combination of number and text). When I publish the data, it is visible in matrix but when a scheduled refresh is completed the data is vanished and we see empty matrix.
I tried to check the datatype as well for Boolean values but didn't find any issue.
Can you please help
This was really helpful! Thanks so much!
This worked for me! My problem was that I had a column ("cancel_reason") which contained a "false" text. The format of the column in the PQ was alphanumeric. I proceeded to change to "text" and that fixed my problem.
That's really helpful. I have same issue and resolved by your suggestion. Thanks for the great help.
Hi Patrick,
Is there any way to subtract the martix tables1 values to martix value 2
I have a similar issue but instead of all my visuals going blank, my already created visuals still work but any new visuals or filters that I try to create end up blank/no data. Any suggestions?
Question, I have a week filter in my power BI report and by default this filter will have the week which is selected during the pulishing. is there any way to adjust this filter to take the most recent week every time we open the report ? ( with out creating additional filters to select)
Yes, 1 option is to add a flag (true/false) calc column logic in the date table and use it as filter.
Logic could be something like, date[current week flag]= if (today's week number= week number of date table) then true else false.
In filter, set this flag=true. Done
Remember to add calc columns as close to the data source as possible.
@@Bharath_PBI Thank you.
But, if I do this I won't be able to filter for previous week's data unless I change the filter to 'No' again right ?
I want avoid this.
Basically, I want to have my report show me the latest week's data but I should be able to see previous weeks data as well by selecting previous week. (But don't want use another filter like 'yes' and 'no)
Does this make sense ?
@@suhassomu1642 Are you saying that you need to rename yes as current week and no as prior weeks?
@@Bharath_PBI
This is how my filter looks :
"
Week No :
1
2
3
4....
"
So, I want to be able to select any week I require but by default I want this to be filtered for most latest week dynamically
Thank you, this worked a treat!
Hi Patrick,
Is there any way to disable auto sorting the columns in Fields pane?... Because my table has 400+ columns and i want to add all those columns into table visual same as in my data source.
If you have a solution , please do a video on it.
Thanks
Jaffer
Yes, that's something really useful. Also when you have hundreds of columns in tables, and when you try to setup relationship, it's a pain to search for the "from" and "to" columns in the manage relationship window.
my data set is updated through gateway refresh but my visuals are not getting updated all this is happening in power bi service
2 Other scenarios i've run into:
1. Using a connector, like exhange, which has different outcomes between Power BI Desktop and the service. For exchange in particular, while on the desktop it uses on-prem exchange. When published to the service it uses exchange online. This is a problem if you don't use exchange online and there is no way to force your dataset to use the correct one.
2. Having a different database user account in your gateway than you are using on-premise. You could fall fowl of row level security where you get rows when refreshing on premise but not when the service makes a call.
Hi there, I have the same issue with a filter disappearing but the filter is based off the following measure.
IF(
MAX('Calendar'[Date])>=DATE(YEAR(TODAY())-1,MONTH(TODAY())-1,1)&&MAX('Calendar'[Date])
Hello @Patrick and all, greetings from Bangladesh. I felt in this problem and tryed to soled. Unfortunatly in particular Droopdown Colom of the Set of Activities (123_ABC) are not appear. So how I will fix the problem. Seeking urgent assistant. Would some one help me in soonest time. Thanks in advance
I am running into this problem now and am using 0 and 1 instead of true and false. If I update the desktop version and publish it works just fine. When the refresh runs overnight all my data is wiped out. Ideas?
I CAN'T SEE VALUES AND FILTER IN BUILD VISUAL IN VISUALIZATION TAB
PLEASE HELP💙💙❤❤
Thanks for the video
Please create a video about how to have a custom message when no data in chart
I don't like to use boolean format because sometimes they fail when using it in a condicional dax when is published in an app. It works Wells in Desktop, in Power service but It brakes in the Power bi Apps. So I prefer to use text format, so It always works well
I ran into a situation where my visualizations seem to be ignoring parts of my data in Power BI Desktop. I can see the data in data view, and even when I slice directly to it, my visualizations don’t see it.
My issue was a synced slicer, watch out for that too!
Thanks, you really helped me! Before I found your video, I lost an hour trying to understand why PBI was acting like a spoiled child 😂 Many Thanks!
Thank you for this one !
thanks for lighting out te problem
👌 excellent tip....
Happened once, after hours of tinkering this was the error. the report maker never set the proper data types with the columns.
You saved my life!
Data types in Power Query, especially when Power Query tries to guess, can cause issues. I tend to try to clear the guess and set them all myself
Thanks for sharing this sir
Thanks.
Doesn't seem right that the product behaves differently between design time and production time.
Can I talk to you?
has anyone faced this problem ?
- source, SQL server views
- credentials to get data worked out perfectly
- published to service
- first of all there was an error ,,schedule refresh not supported for at least one of sorces,, after refresh this has changed
- now I have greyed out credentials and I am not able to edit them thus, scheduled refresh is not available
- have tried to edit in pbi desktop in data source settings credentials, even deleted and created again - no change
- in pbi service under dataset I can see under Database - connection status ,, unable to connect,,
- anyone any idea? Have tried also pbi commuity, no help
- and no there is no need or a plan to use personal gateway
Why not just filter on Country versus True v False column? Or no filter at all and use bookmarks
Different ways for different scenarios. Answer is It depends!
1) When there's thousands of countries (or cities) cardinality is high, whereas true/false column will always have a cardinality of 2 or 3, if nullable.
2) Performance (of filter, fetching values) will be good if you slice/filter on low cardinal columns
3) In some cases, business identifies certain things as flags, which is mostly true/false scenario, which Patrick's demo uses.
I could think of these 3 at the moment.. Someone can add more to it.
@@Bharath_PBI Ahh. Good points. I rarely deal with huge cardinalities so a Boolean check would be much faster
Super 👌